Skip to main content

Explorer Guide: Compare and filter

This applies tov2.24

We’re going to look at two quick ways to create comparisons: if you’re using the Time View, you can add measures to do side-by-side comparisons. Or you can add compare groups.

Then we'll take a look at using filters with your queries. 

Using measures

Adding another measure is easy: click Add Measure, select what you want to measure (and how you want to measure it), then click Go. This will plot two (or more) different measurements across the same time range.

For example, you could compare the total number of events and the number of unique user sessions:

Using compare groups

You can add a compare group only when you’re using a single measure. This performs the same measurement across different groups, and uses the value of the column that you selected as the basis for comparison.

For example, you can compare the number of events created by all Wikipedia users:

This comparison shows that the most common editors on Wikipedia are bots: no human could make 1.7 million changes in the 10 days spanned by the query. Even the tenth user on the list made 155,555 edits in 10 days, which is about 650 changes per hour. 

Using simple filters

Use Simple filters to quickly select one or more columns or metrics to use as a filter. For example, we can look at the users who uploaded files. Select the log_action column, then is one of, then the value upload.

You can add multiple filters like this. When you add multiple filters, they’re automatically combined with ANDs; so, for example, you can use a filter to view only paying users and include only users in the San Francisco-Oakland-Hayward area.

Using advanced filters

Use the Advanced option to create a more complex filter. You’ll have to write these out, but you can build detailed filters and join multiple filters with AND or OR operations, such as:  `log_action` in ("upload")or `log_action` in ("delete", "remove")

If you added these as multiple Simple filters, Interana would interpret this as where the value of log_action is either "upload," "delete," or "remove."

You can also start with a simple filter, and then switch to an advanced filter. When you do this, Interana automatically converts the simple filter into advanced syntax, which makes it easy for you to extend the filter. See Advanced filter syntax if you'd like to see more detailed information.

Comparing data

Finally, use Compare to compare the results of two or more filtered queries. When you use this option, the results of the query run against the filters you define in the “A” group are compared to the results of the filters in the B group (and C, and D, and so on, if you want to add more).

Modifying the query from its chart

You can also change the query by changing options on the chart itself.

Filtering to a specific group

If you’re comparing groups, click a data point to filter to or filter out that data. This 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, if I select Filter to this, Interana automatically creates a Basic filter: “wiki is one of wikidatawiki,” and shows only that area in the chart:

Similarly, if you select Filter this out, the filter statement will use the “is not one of” syntax and will show you everything but what you selected.

Changing the time range

Just like clicking and dragging a time range on the time scrubber, you can click and drag horizontally across the data in a Time or Stacked Area Time chart to narrow the time range. This is useful when you want to see more detail about a specific area of the chart.

After you select the area you want to look at, Interana runs a query using the new time range.

  • Was this article helpful?