Skip to main content
Interania

Query Builder reference

0votes
2updates
10views
This applies tov2.22

The Interactive Query Builder is the set of controls on the left side of the Visual Explorer.

Explore

Field Description
Dataset Select the dataset with the data that you want to analyze. Click the Settings icon in the left navigation pane to view detailed information about the datasets.   
View Switch between Views to visualize the results of your queries in different ways. See Views and chart controls for information about the different Views and the chart controls available for each View.
Global Filters Global Filters are filters that your admin can pre-build for you to use with your queries. See Create and use Global Filters for more information.

Time

Field Description Can be used with these Views
Start / End Define the time range for a query. You can use the date selector or type directly into the fields. See Time query syntax for more information about setting the time ranges. All Views
Compare Times

Compare the time range you selected to a prior time period. For example, you can use this to look at a measure week over week to see how it changed.

  • Time
  • Table
  • Number
  • Distribution
  • Bar
  • Pie

Measure

Field Description Can be used with these Views
Measure Select what you want to measure and how to measure it. This can be a count or an aggregation over a field, such as an average or median, or ratio metrics that you have created.  
  • Time
  • Table
  • Number
  • Bar
  • Pie
  • Stacked Area Time
  • Stacked Bar
  • Retention
Column If you are using a column as a measurement (for any metric other than Count Events or ratio metrics), select the column to use. This can be a column in your dataset, a derived column, metrics that you created, or metrics generated automatically when you create sessions and funnels.

All Views

Add Measure You can add multiple measures to do side-by-side comparisons. 
  • Time
  • Table
  • Bar
  • Pie
  • Stacked Area Time
  • Stacked Bar
  • Retention

The default measures include:

Measure Description
Count Events A simple count of events matching the query
Count Unique Acount of unique field values within a column matching the query.
Sum The sum of the numeric values of all results returned for a query. Valid only for numeric data.
Average The average (mean) value of a given parameter over time.
Median The median value (50th percentile) of a given parameter over time.
Minimum The lowest value that matched the query at any time during the specified time period.
Maximum The highest value that matched the query at any time during the specified time period.
Percentile The value at the selected percentile for a given parameter over time.
Ratios Ratios divide the result of one measurement by the result of another. You can use pre-seeded ratios or create your own.
Create Measure Click this to create a new ratio measure.

See Metrics, Measures, and Aggregators for more information. 

Compare

For some views, you can visually compare two or more attributes by grouping results in multiple dimensions. 

Field Description Can be used with these Views
Groups

Segment your query by one or more fields, metrics, or sessions to group your results in multiple dimensions. 

You can use Compare with the Time, Table, Bar, Pie, Stacked Area Time, Stacked Bar 

  • Time
  • Table
  • Bar
  • Pie
  • Stacked Area Time
  • Stacked Bar 
Stack by For the Stacked Bar view, you can vertically split ("stack") the bars by a field, metric, or session.  Stacked Bar

Filter

Use filters to control which data is included in the query and visualization. Click Simple to select a column from your data, or a custom metric, funnel, or session. Click Advanced to enter a text query. Click Compare to compare two or more attributes by grouping results in multiple dimensions.

Filter option Description Can be used with these Views
Simple Select one or more columns or metrics to use as a filter for your query. If you add multiple filters, they are joined in an AND operation. All Views
Advanced Choose this option to enter a text filter, such as ((x="a") or (y="b")) and (z>1000). You can join multiple filters with AND or OR operations. See Advanced filter syntax for more information. All Views
Compare

Choose this option to compare the results of two or more filtered queries.

When you use the Compare filter, the results of the filtered query A will be compared with the results of query B. Those queries can be further specified by choosing Add Filter.

Note: You cannot use a Compare filter and a Compare group in the same query. 

  • Time
  • Table
  • Distribution
  • Bar
  • Pie
Add Filter Add more filters to your query. All Views
Add Compare Group Use this to compare more than two filtered queries.
  • Time
  • Table
  • Distribution
  • Bar
  • Pie
  • Was this article helpful?