Interana’s living dashboards give you snapshots of data analyses and let you perform quick and easy analyses of your own. With the dashboards, you can explore from any panel on a dashboard to the live query in the visual explorer. The raw data is live behind the charts; the parameters used to create them are pre-set, but you can quickly start exploring on your own by modifying a few simple time settings and adding filters.
If you started using Interana as a Tourist, you were focused on consuming data analyses without being directly involved in building queries. But now that you’ve had some time to work with dashboards, you’re ready to start working with queries.
Now it’s time to move on and become an Explorer.
Exploring from a chart
Looking at the charts in the Dashboards tab, you might have noticed that every chart has an Explore link in the lower-right corner.
Click one of those links to go to the Explorer tab, where you can see the chart in more detail, as well as the query used to build the chart.
On the left, you can see the parameters that are used to build this query. We call this the Query Builder. In this example, the query counts the number of users (
Count Unique userId) and groups the results by level, which graphs the number of people using the free service versus people paying for a subscription.
You can change these parameters to explore further. Maybe change the time range, or add a filter. For example, are the results of the query different for a particular artist? Remember that you can add filters to limit the data included in the results. This lets you focus on the data that you’re most interested in. If we filter to a specific artist (in this example, Rihanna), we can see that while the activity of paid users who listen to Rihanna has a similar pattern to the overall usage of all paid users. But the activity of the free users is lower; maybe people who listen to Rihanna are more willing to pay for a subscription?
Modifying the query from its chart
You can also change the query by changing options on the chart itself. If you click a data point, you can filter to or filter out that data, which creates a filter that says, basically, “only show me that data” (filter to) or “show me anything except that data” (filter out). We’ll talk more about filters later.
Next: Build a simple query