Hello Peers,
do you know if there is a way or workaround to enforce an update of the upper threshold in a Single-KPI component when a filter is applied on the dashboard. Currently, the upper threshold if calculated on all data once but it does not react on a filtering.
w/o filtering:
w/ filtering:
Hope, you guys have an idea on that matter ;-)
Cheers,
Mark
Hi Mark,
can you share PQL code with us? I had similar problem in the past.
Best Regards,
Mateusz Dudek
Hi Mateusz,
it's nothing magical:
For the KPI:
COUNT (DISTINCT
CASE
WHEN "_CEL_CASES"."SYSTEM" = 'SYSTEM_A'
THEN "_CEL_CASES"."FORM_ID"
END
)
For the upper threshold:
COUNT (DISTINCT "_CEL_CASES"."FORM_ID")
And the filter it a simple frontend filter choosing a certain month. I just wonder why the KPI is updated, but the upper threshold is not. Therefore, I hope there is a way to enforce an updating calculation of the thresholds as well.
Best regards,
Mark
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
