My previous blog explained creating calculated measure using Schema Workbench. This blog will let you know how to add a calculated measure that fetches % of measure relative to a particular dimension in Pentaho User Interface.
Make data easy with Helical Insight.
Helical Insight is the world’s best open source business intelligence tool.
Prerequisites:
Pentaho BI Platform.
Consider the below cube which is already published in Pentaho BI Server. One of the working scenarios of the cube is used for demonstration i.e. amount which is spent relative to time and store country.
To create calculated measures which calculates relative percentage in a user interface, follow the below steps:
- Click on ‘Add’ button beside Measures.
- Click on Predefined Calculations
- Enter the details according to the requirement as shown.
- Click on OK, execute the cube and drag created calculated measure.
It gives the relative percentage change of amount according to Store Country.
In case if you have any query please get us at support@helicaltech.com
Thank you
Mounika
BI Developer
Helical IT Solutions Pvt Ltd
Free Open Source BI Platform
- AI-Powered Analytics
- Embedded Analytics
- Single Sign-On (SSO)
- Multi-Tenancy
- Paginated Canned Reporting
- Interactive Dashboard
- White Labeling