Skip to main content

Sandbox Deployment Guide: build and pin a query

The basic definition of a query in Interana is measuring the actions of an actors whose data exists in a certain dataset over a specific period of time. So a basic query could be “how many unique users visited my site last week?”

In this section, you will:

  1. See how to build a simple query
  2. Learn how to use groups and filters to modify the query
  3. Learn how to pin a query to a dashboard so you and your colleagues can refer to it later

Build a query

See the How it Works guide for a more complete explanation of Interana, but here's a quick explanation of how you'll use Interana's Visual Explorer to build a query:

  • Dataset: you might have one dataset; if you have more than one, check the Settings tab to look at your datasets in more detail, and use that to find the datasets that have the columns for your query. You’re looking for a dataset that includes Users as actors (in this case, your data needs to track unique users).

  • View: the Time view is good if you want to see how activity changed over time, but use Table or Number if you want a single count of all activity.

  • Time: what time period are you interested in? In this example, we're looking at events from last week ("7 days ago" to "today").

  • Measure: this is what you're measuring and how you're measuring it. This example is measuring the number of unique users ("Count Unique users"). Your “user” column might have a different name; pick the one that tracks unique users.

(Also see the Query Builder reference for detailed information about the Query Builder.)

Start by going to the Explorer page of your Interana instance. 

The Time View shows you how the number of users varied over time. You can see that the number of active users increased during the day in the United States, but dropped sharply at night.

Switch the View to Number to see how many unique users visited during the last week (you can use the Table View if you want a more precise figure):

The Number View automatically compares your results to 1 week earlier by adding a "1 week before" time compare value.

Adding groups and filters

Now add a column to the Compare field to split the results into groups. This example groups the results by the column, showing the events associated with specific countries (as identified by the users’ IP addresses). This result looks good as a Stacked Area Time View (I also de-selected *null* to show more detail about the events I’m really interested in):

That's a simple query; your data will have more columns of data to explore, and you can also use filters to refine your query and focus on the details that are important to you.

Next, you can filter to a subset of the results. For example, you can add a filter to only see visitors from South America. The filter we used is ip.continent is one of SA(South America).

Pin the query to a dashboard

After you run a query and like the results you’re seeing, use the Pin to Dashboard button in the upper-right corner to save a chart to a dashboard. This lets you use Interana's living dashboards, where you can save the chart with a meaningful name and come back to the query later and share it with others (if you pin it to a shared dashboard). And more than that, you can modify the queries within the dashboards. 

What's next?

Now you've installed Interana, added your data, and seen a sample of how you can use Interana's Visual Explorer and Living Dashboards. Now that you're ready to take your next steps with Interana, read the Explorer Guide to learn more!

  • Was this article helpful?