BOOK A CUSTOM DEMO

Formula KPI Configuration

Formula KPIs in Presto PDCA are powerful tools that allow users to track complex metrics derived from multiple data sources. These KPIs are built using configurable formulas, combining various numerical feeds to create a single, meaningful metric. When setting up a Formula KPI, users can define custom fields for manual entry, configure automatic data feeds, or even reference other KPIs as input sources. This flexibility allows for seamless integration of different data points, making it easier to capture and report sophisticated performance indicators.

Formula KPIs are especially useful for metrics that require aggregation or calculations from multiple sources. For example, Employee Productivity Rate can be calculated by dividing hours worked by output volume, combining input from both time-tracking and production systems. Similarly, Gross Profit Margin may be configured as a Formula KPI by subtracting cost of goods sold from revenue, using sales and expense data. Other examples include Customer Retention Rate, which could be calculated using new and returning customer data, or Cost per Acquisition, derived by dividing total marketing spend by the number of new customers acquired.

By configuring Formula KPIs, users can monitor and manage complex performance metrics with greater precision, allowing for more accurate, data-driven insights across the organization.

Creating Formula-Based KPIs

Use the formula function to create multi-data KPIs

1. Select team

2. Access the KPI Workbench

3. Select KPI

4. Access the Formula Configuration panel

5. Click here to create customized formula

6. Create customized field (1)

7. Add first customized field

8. Repeat

9. Add second customized field

10. Prepare to enter formula statement here

11. Enter formula statement here

12. Save

Congratulations! You have completed the exercise

This website uses cookies, including third-party cookies, to guarantee you the best experience on our website, analyse traffic to this website, show you personalised ads on third-party websites, and provide you with social media features. You can change your preferences at any time by accessing the cookie settings. For further information, please read our Cookie Policy