Skip to main content

Explorer Guide: Build a simple query

This applies tov2.22

The Query Builder sits on the left side of the the Explorer tab, which is the front page of Interana. It’s the portal to your data, the primary way for you to ask ad-hoc questions by building queries and using different views to drill down into your data.

When you build and run a query, Interana shows the results as a chart to the right of the Query Builder. More specifically, it could be a chart, a graph, or another visualization, but we’ll call them charts. You’ll see a visualization of your query results, a summary of the query you used, and a set of tools that you can use to adjust the chart display (in the Chart Controls). The specific controls depend on the View that you selected; we’ll talk more about that later.

Start by selecting a Dataset (a collection of your event data) in the Query Builder. The good news is that you probably only have one, maybe two to choose from. Now select a View (how we want to visualize the data). The default one, Time, is a good choice, but you can select Samples if you want to see the raw values, or something like Distribution, Bar, or Pie if you want to see a different visualization of your data. But it’s a good idea to start with the Time View.

Choose the time range for the query, or, again, use the default. The default shows you what happened over the last week, but it’s easy to select a different time range. You can either use the Time fields, or you can click and drag over the time scrubber just underneath the chart.

Now you’re going to start making more interesting choices. First, you’ll select what you want to measure. A measure can be almost any count or aggregation over a data column (such as an average or median), metrics that you create, or metrics that Interana creates automatically when you create named expressions (specifically, when you create sessions and funnels).

The default measure, Count Events, does exactly what it says: it counts the number of events that occurred in the time period that you set. If you’re using the Time View, it plots the number of events over time. Simple, right?

With Interana, you have many ways to measure your data beyond counting the number of events. Take a minute to look at the available options in the drop-down list.

Next: Compare and filter

  • Was this article helpful?