During the last month, what is the average and maximum number of upload actions performed every day?
For this query, we want to measure events (uploads), but instead of showing the total number of actions per day, we want to show both the average and maximum values.
We'll create a simple metric to give us a count of events, and then we'll build a query that takes the average and maximum values of that metric filtered to the specific "upload" action that we're looking for.
This example shows how to run multiple measures in a single query.
Building the query
We'll start by creating a simple count events metric. Although Interana has a built-in Count Events measure, using the built-in measure will give us a sum of all events and we want to see the average and maximum values. But we want to performing arithmetic operations on the metric, so we'll create our own.
Create a new metric that counts uploads events for your actor. In this case, the
user column contains the actor information, and we'll add a filter to have this metric look at upload actions.
Now we'll use this metric to build the query.
Select the time range: in this example, I'm looking at data from 1 month ago to now.
Next, select Maximum in the Measure field, then select the metric that you just created.
Click Add Measure, then select Average and your metric.
Run the query to view the average and maximum count of events over time.
You can also add more measures, such as the minimum, median, and total numbers of events. Use the labels under the chart to highlight or show/hide the lines that you'd like to explore further.
Tip: using a secondary y-axis
If you are using two measures in a Time view and the results are at very different scales, the default view can result in one chart with the smaller chart being flattened. In this case, you can adjust the display to show both results in a more meaningful visualization.
Click Use Secondary Y-Axis to add a second y-axis to the chart.
Now you can compare the shape of the two lines. In this example, this option lets you see how closely the average and maximum values correspond. But be sure to pay attention to which line corresponds to which axis!