Question
How to implement dynamic "Ratio of Totals" calculation in Freedom UI Dashboards (Filtering Issue)
20:33 May 06, 2026
Current Setup:
I am working in Freedom UI. Currently, I have a KPI called "Margin per Liter (Excl. VAT)". It is calculated via a Business Process that:
- Sums up the "Margin without VAT" for all orders.
- Sums up the "Quantity (Liters)" for all orders.
- Divides the first sum by the second.
- The Problem: The result is saved into a specific field within a single "dummy" Order record.
The Issue:
Since the value is pre-calculated and stored statically in a record, the Dashboard indicator does not react to Quick Filters (Period, Owner, etc.). It always shows the same total regardless of the filters applied on the page.
Goal:
I need the dashboard to calculate this ratio dynamically: $\sum(\text{Margin}) / \sum(\text{Liters})$. It must recalculate every time a user changes the filter (e.g., to see the margin per liter for a specific manager or last month).
Questions:
- How can I set up a "Ratio of Sums" in Freedom UI without using a background Business Process?
- Is there a way to use the "Formula" source in the Indicator widget to divide two different aggregated sums while maintaining filter context?
- What is the best practice for such "weighted average" metrics in Freedom UI to keep them responsive to page filters?
Like
0 comments