SAP Lumira is a powerful self-service data visualization and analytics tool designed to empower business users to transform data into insightful visual stories. One of its key features is the ability to create calculated measures and formulas, which enhance analytical capabilities by enabling users to perform custom calculations on their datasets.
This article explores the process of adding calculated measures and formulas in SAP Lumira, providing step-by-step guidance, use cases, and best practices.
These capabilities help users derive deeper insights without altering the original data source.
Here are several reasons to use calculated measures in SAP Lumira:
Launch SAP Lumira and open your dataset. Navigate to the Prepare room, which is designed for data preparation and transformation.
A formula editor will open.
Give a name to your calculated measure.
Use the formula editor to build your expression.
Example:
[Sales Revenue] - [Discount Amount]
This formula calculates the net revenue after discounts.
Formulas can also be added as calculated dimensions or columns in the dataset.
Example:
IF [Sales Amount] > 10000 THEN "High" ELSE "Low"
This creates a new column that categorizes sales into “High” and “Low”.
Profit Margin Calculation:
([Revenue] - [Cost]) / [Revenue] * 100
Conversion Rate:
[Number of Leads Converted] / [Total Leads]
Sales Growth:
([Current Month Sales] - [Previous Month Sales]) / [Previous Month Sales]
Adding calculated measures and formulas in SAP Lumira significantly enhances its analytical power, enabling users to generate custom metrics and derive actionable insights. Whether you're calculating profit margins, categorizing data, or creating KPIs, mastering this functionality is essential for making the most of SAP Lumira.
By following best practices and understanding how to use the formula editor effectively, users can transform raw data into impactful visualizations and stories.