Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone!
I would like to know how to set up a KPI to zero and then change it according to the counts.
Thanks in advance.
Fiorela
Hi,
For the first one you can create:
Count({$< Category = {"$(=Only(Category)"}>}ID)
For the other one:
Count({$< Category =- {"$(=Only(Category)"}>}ID)
Now you need to select a Category to make it work.
Jordy
Climber
Hi,
Can you elaborate a bit more what you want? Maybe with an example?
Jordy
Climber
yes, my idea is set the kpi by default to zero. For example:
Table1
ID
Juan
Maria
Raul
Carlos
Table2
ID,Category
Juan,A
Raul,B
Carlos,A
then, the first KPI could be how many A do I have = 2.
The second KPI could be "how many people do NOT have 'A' " : 2 (raul and maria)
(Count [ID] table1 - count {category=A } [ID] table 2), so this KPI i would like to set to zero by default, i.e The first display of it should be zero, and then, when I filtering by category = A, change to 2.
I hope this helps. Thanks in advance.
Hi,
For the first one you can create:
Count({$< Category = {"$(=Only(Category)"}>}ID)
For the other one:
Count({$< Category =- {"$(=Only(Category)"}>}ID)
Now you need to select a Category to make it work.
Jordy
Climber