Marple Docs
  • Introduction
  • Marple Insight
    • Welcome
      • What is Marple Insight?
      • FAQ
      • Feedback
      • Release Notes
      • Roadmap
    • Setup and Configuration
      • Data connection
        • Supported Databases
          • Azure Data Explorer (ADX)
          • Microsoft Fabric
          • TimescaleDB & PostgreSQL
          • Mireo Spacetime
          • InfluxDB (Beta)
        • Connection configuration
          • Required Queries
          • Optional Queries
          • Templating
      • Deployment
        • Infrastructure
        • Identity Providers
        • Hardware
      • API
      • Python SDK
    • User Manuals
      • Data Library
      • Visualisation
        • Add Data Sets
        • Signal List
        • Functions
        • Plot types
          • Time Series
            • Signal Settings
            • Limits and Stacking
            • Zooming
            • Cursors
            • Text data
          • Scatter
          • Map
          • Frequency (FFT)
          • Aggregates
        • Mouse Actions
        • Tabs
        • Reorganise Plots
        • Compare data
        • Realtime
        • Export image
      • Motorsport Package
      • Flight Testing Package
      • Projects
      • Sharing
      • Team and accounts
        • Workspaces
        • Account Types
      • Keyboard Shortcuts
  • Marple Files
    • Welcome
      • What is Marple Files?
      • Quick Start
      • FAQ
      • Release Notes
    • User Manuals
      • Data
        • File Types
        • Time Precision
        • Data Points
        • Upload Data
        • Organise Data
        • Influx DB
      • Visualisation
        • Overview
        • Plot types
        • Mouse & Keyboard
        • Calculated Signals
        • Overlay Data Sets
        • Projects
        • Annotations
      • Analysis
        • Metric Builder
        • SQL Editor
        • Marple AI (GPT)
      • Reporting
        • Create Reports
        • View Reports
        • Share Reports
        • From data library to reports
      • Sharing and Accounts
        • Sharing
        • Team
        • Settings
      • For developers
        • API Access Tokens
        • API Guide
        • Python
Powered by GitBook
On this page
  • Builder
  • Metric
  • Filter
  • Group by
  • Results
  • Table
  • Bar Chart
  • Trend Line
  • Add Data
  1. Marple Files
  2. User Manuals
  3. Analysis

Metric Builder

Perform powerful calculations across multiple data sets

PreviousAnalysisNextSQL Editor

Last updated 3 months ago

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

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.

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
Marple Analysis Window
Metrics
Group by signal
Result in table format
Result in bar chart
Trend line of a metric