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 user) and filters the results to show new user creation events (
logtype is one of newusers,
log_action is one of create [or]
You can change these parameters to explore further. Maybe change the time range, the view, or add a filter. For example, we can switch to a Time view to see how the creation of new accounts varies over time.
We're using filters to limit the data included in the results. This lets us focus on the data that we're most interested in In this example, we're using filters to limit the results to the creation of new user accounts. There are many different values for
log_type, and even more for
log_action (for example:
thank are other actions that can be performed on user accounts).
We can also add a Compare group to group the results. For example, what if we change this query to a Time view and then compare the creation of new accounts across the different wikis?
We see that most new accounts are created on enwiki, with commonswiki following in a distant second place.
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).
In this example, you can hide the enwiki line (Filter this out) because it's overwhelming the others:
The Y-axis shifts to match the other values.
We’ll talk more about filters later.
Next: Build a simple query