Custom Measures

Last modified: May 13, 2022

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.

Another example would be 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.

Datasets page

 

2. Select Create custom measure.

Click on 'Create custom Measure' button at the top right to start.

3. Name your Custom Measure and select the corresponding numerator and denominator.

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

Averages

Examples: Average sales per order, average quantity per customer, average cost per product.

To create averages, you need:

  1. At least 1 measure (sales, quantity, cost, etc.)

  2. 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.

Set a column to be a segment

Averages are calculated automatically by Auto Insights and available on Discover, Missions, and Search.

Averages are calculated automatically

Ratio

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.

Create Ratio

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. 

Set to visible

Was This Page Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support. Can't submit this form? Email us.