Custom Measure
Last updated
Last updated
A Custom Measure in Recurve enables users to create new numerical calculations within a Cube, enhancing data analysis and reporting capabilities. These measures help define key business metrics that may not exist explicitly in the raw dataset.
A Custom Measure is a user-defined metric derived from existing fields using aggregation, mathematical operations, or conditional logic. These measures help refine insights and provide additional flexibility in data analysis.
New Business Metrics: Defining KPIs such as "Profit Margin" using ((Revenue - Cost) / Revenue
).
Conditional Aggregations: Creating measures like "High-Value Orders" for transactions above a certain amount.
Ratio & Percentage Calculations: Computing values like "Conversion Rate" as ((Total Sales / Total Visitors) * 100
).
Custom Weighting: Applying business rules to weigh certain values differently in calculations.
To create a custom dimension, follow these steps:
Ensure the cube's primary key has been set before proceed to create the custom dimension. Refer
Click on + button, select Add a measure
Fill in the details in the modal:
Field label will be auto populate based on the Field name
When entering the custom formula, you can click on the fields on the list to auto populate into the formula box.
For Aggregations and sample use case, refer to Aggregation Function
Click on Validate button to validate the formula
Ensure that the custom formula matches the type of database connected.
Once no error detected, click on Add button to add the custom dimension into the cube.