Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a KPI where I'm counting the number of stores such as
=count(distinct {<STORE={'one'}>}ID)
The thing is that If I select a STORE different than one, I don't want the count to take place.
How could I achieve this without an if and just with set analysis?
Thank you.
Best regards.
aggregating by the same field solves the issue:
aggr(count(distinct {<STORE={'one'}>}ID, STORE)
Hi, maybe with * operator:
=count(distinct {<STORE*={'one'}>}ID)
aggregating by the same field solves the issue:
aggr(count(distinct {<STORE={'one'}>}ID, STORE)