Introducing Custom Measures
Using Astrato's Custom Measures, create the metrics that suit your business using orders of operation with multiple fields, aggregation, and filters- no coding required.
There's also no new syntax or structures to learn. It's a simple point-and-click to create custom measures.
Custom measures, also known as calculations, advanced measures, or multi-field measures, add flexibility to your model.
You can include your custom measure in any workbook. Create your custom measure using the functions, fields, and filters, and save it as a new measure with a description.
Please note: Custom measures are not supported with Google Sheets.
Building your custom measure
Adding a custom measure
Once you've added and selected the data you want to use in the Data View Editor (DVE), click Define to set up your dimensions, measures, and joins.
Click Add in the Measures section to view the Create Measure dialog and the first measures block.
Selecting aggregation functions and fields
Select the operator for your measure in the first field.
Select the field you want to measure; at this stage, you can add a filter to refine your measure.
Click the Add filter button at the end of the row to create a filter.
Select the field to filter, select from the operators, or if you select a date, you can choose a predefined period.
Select the format if it's an operator or if a date, then one of the predefined date options.
Name your measure, and add a description if you want to.
Click Create. You can now use the measure with the data in your workbook.