Skip to main content

Explorer Guide: Compare and filter

This applies tov2.21

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.

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:

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, earlier we compared the total number of free vs. paid users:

In this example, we’re looking at all users (userId), and splitting the total by the values free and paid.

Using simple filters

Use Simple filters to quickly select one or more columns or metrics to use as a filter. For example, if you want to exclude results from New York City, you can select the city column, then is not one of, then the value New York.

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 ((`city`="New York") or (`city`="San Francisco")) and (`sessions`>1000).

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: “artist is one of Gorillaz,” and shows only that line 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 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?