How to convert KPI value to constant? Also, this constant should be insensitive to filters.
Page 1 / 1
Have tried using PU_max(constant(), KPI), however the value changes with other dropdown selections/ filters. Is there any alternative way of generating constant value?
Have you tried using a static value variable? That seems to work for me. (Expand to see screenshots)
- I grabbed a random dataset with 4281 cases.
- Made a static variable which counted the number of cases (4281).
- Made a component showing said variable.
- Then applied a filter which reduced the number of relevant cases from 4281 to 2.
While the number up left shows 2 out of 4.28k, the static variable still shows the full 4281. Hope this helps!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.