Issue with report of an automated formula when filtering by date
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-03-2025 07:47 AM
Hi everyone,
I have a scheduled job that runs monthly and captures some values. Each record created by this job contains:
*NumA
*NumB
*Percentual = (NumA/NumB)*100
On this records there are some automated indicators, one for the sum of the numA, another for the sum of the numB and an automated formula to calculate the percentual, these are being generated correctly.
However, when I create the report on this automated formula and apply a date filter, the calculation does not work as expected. The automatic indicator seems to be summing the values across all days, so when I filter by a specific date range, the formula indicator still shows the overall total instead of the filtered calculation.
Has anyone faced this before? Is there a recommended way to configure the report (or the indicator setup) so that the calculation works correctly within the selected date range?
Thanks in advance for any help!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-03-2025 08:03 AM
Can you share more information and sample KPI dashboard of the issue you are facing ?
As you might know, formula indicator scores are not stored in the database and it is pulled runtime based on defined formula indicator & when viewed in the KPI dashboard.
It is possible you are using time aggregation and function as 'Sum' which is displaying the data in a format you are not expecting.
If this helped to answer your query, please mark it helpful & accept the solution.
Thanks,
Bhuvan
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-03-2025 10:39 AM
Bhuvan,
As you can see on the attachment we have the "Numerador" is the numA and the "Denominador" that is numB, and the percentage that are the formula.
There is two automated indicators for each num, that sum the value on the field of all the registers and that formula indicator that make this percentual.
The automated indicators is set as 'Sum', we notice that the value of indicators filtered by day is allways the same, the indicator is always sum all values, you now a way to make it sum just the values of each day?
Thanks.
