Sometimes, we require a specific measure to be set up on the fly that is a combination of measures from the dataset. With Custom Measures, we can now create new measures that were not part of the existing data.
Currently available calculations are:
Division of 2 measures (sum)
Division of 2 Measures (sum)
One example is to calculate the Loan-to-ratio value, where we take the total loan amount divided by the value.
Another example is to calculate the average price per item, where we take the total sales amount divided by the total sales quantity.
You can edit or delete the Custom Measure at any point in time.
Can I compare Custom Measures with different time periods?
Yes, Custom Measures work like a standard key measure, where you are able to identify trends over time and set specific comparison periods.
Who can create custom measures?
Only Dataset Admins are allowed to create custom measures.
How do I create a Custom Measure?
1. To access this feature, go to Datasets > ellipsis icon > Edit settings. Then select Custom Measures.
2. Select Create custom measure.
3. Name your Custom Measure and select the corresponding numerator and denominator.
Where will Custom Measures appear?
Custom Measures display in Discover, to provide you with a helicopter view of the trend over time and the breakdown across each segment. As well as in Missions, where you can curate the analysis further by adding filters and comparing across segments.
Set Up Averages and Ratios
Examples: Average sales per order, average quantity per customer, average cost per product.
To create averages, you need:
At least 1 measure (sales, quantity, cost, etc.)
At least 1 segment (customer id, department, office location, etc.)
Auto Insights will calculate all possible combinations of averages i.e. Average Sales by Department, Average Quantity by Office Location, etc.
Set Measures and Segments
This can be set up in the data ingestion part.
Averages are calculated automatically by Auto Insights and available on Discover, Missions, and Search.
Examples: Price (Sales over Quantity), Lending vs. Revenue ratio
To create a ratio:
You need a minimum of 2 measures.
Have admin access to the dataset.
Create a Ratio
To set up a ratio, go to Discover > Edit measures list > Custom Measures.
Make it Visible
Once you create a ratio, make sure it is set to visible. To do so, go to Set key measures for this dataset. Drag from the Hidden measures column to the Key measures column.