Metric Builder
Perform powerful calculations across multiple data sets
The easiest way to perform aggregations on one or multiple data sets is by using the Metric Builder in the Analysis window of Marple.
Builder
The Metric builder consists of 3 components:
Metric
Filter
Group by
The builder is meant to make it easy for the user to perform calculations on data. If you want to create more complex calculations, you can use the SQL Editor.
Metric
In the metric part of the builder, you need to define the aggregation method and signal you want to apply it to. You can define multiple metrics.
Currently, the following aggregation methods are available:
Average
Minimum
Maximum
Sum
Count
Filter
In the filter section, you can define the conditions on which you want the metric to be calculated. Setting a filter is optional. If you define multiple filters, they all need to be true (eg. filter1 AND filter2).
Group by
In the group by section, you can define how the data needs to be segmented. There are three options:
All data sets
By dataset
By signal
1. All data sets
Merge all data and perform the calculations as if it was 1 data set. 1 result per metric will be returned.
2. By dataset
Perform the calculations per dataset individually. For each data set, the results of the metrics will be returned.
3. By signal
This is where things become a bit more complex. You can also select the results to be grouped based on a signal. Select a signal and how many buckets you want across a certain range. If you have multiple data sets loaded, the results of all data sets will be merged.
PS: Be careful if you are dealing with integers, you might need to move around the boundaries in order to get the result you want.
Results
The result can be displayed in 3 different ways:
Table
Bar Chart
Trend Line
Table
The raw results of the calculation defined in the metric builder can be shown in a table format. In this case, we grouped on a signal, so the first column shows the bucket range. Note that you can sort the table on every column by clicking on the column title.
Bar Chart
Often the results can be visualised in a bar chart. Note that you need to select the correct metric that you want to see in the bar chart.
Trend Line
The trend line shows how a certain metric evolves over time. This option is only available when you group by dataset and when you use absolute timestamps in your data.
Add Data
In order to get data in the metric builder, you need to add data from the Library and press 'Analyse' instead of 'Visualise'. Even if you have data open in the Visualisation view, you still need to add them to the Analysis view as well.
Last updated