Query Builder reference
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. |
|
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. |
|
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. |
|
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 |
|
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 Basic 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 |
---|---|---|
Basic | 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. |
|
Add Filter | Add more filters to your query. | All Views |
Add Compare Group | Use this to compare more than two filtered queries. |
|