Query is a Formula used to get Simple Measures from user events using mathematics functions like counting and aggregation (min/max/sum/avg), and compute Compound Measures using + and / operators on multiple Simple Measures.
Measure includes one Function (eg "Count Events") applied to at least one set of Events each can have its own Event Filters.
- Name: you can provide a name for each Measure so they can be easily identified on the result analysis chart. If the name is not specified, a default name like M1, M2 will be used.
- Format: you can decide how to format the Measure in the chart by selecting between #, % and $, and also specify the number of digits to keep.
- Saved Measure: you can save a measure when it is completely defined. All Saved Measures will be available in the Measure dropdown list for others to reuse.
You can use the math operator sign buttons in the lower-right corner to combine multiple Simple Measures into a Compound Measure, mostly ratios. For example:
- Listens/DAU = Count Events(Listen) / Unique Users (Login)
- Download Failure Rate = Count Events(Download Failed) / ( Count Events(Download Success) + Count Events(Download Failed))
Each Function can be applied to multiple groups of Event(s) each may have different filters.
- Count Events: count number of events
- Unique Users: count unique users with distinct User Id
- Unique Values: count unique number of values for a certain Event Property
- Min/Max/Sum/Average: aggregation functions on a certain Event Property
After specifying Measure(s) with Function and Event(s), you can also provide Global Filters (applicable to all Measures in the Query) and Groupbys (Breakdown or Cohort), then specify the Time criteria to execute the Query to get the analysis presented as a chart.
- Chart Type: you can toggle between different chart types, including Line, Bar, Stacked Bar and Stacked Percentage Area (last two only available when Groupbys are specified).
- Data points: mouse over a certain date to see the values for each group on that day
- Moving Average: display 7-Day Moving Average (MA7) line
- Hide/Show Certain Groups: the float number displayed in the dropdown list is the Pearson Correlation Value between this group and the total lines.
- Export to CSV or Jupyter Notebook: from the context menu on the top-right corner of the chart