Creating a calulcated field using a PRE_filter quantity

Q&A
,
1

Hello,

I would like to calculate this percentage

distinct_countIf(locations,{has items}='Yes')/distinctCountOver(locations,[],PRE_FILTER)

but it gives me errors of aggregation

2

Hello @remba87

Can you try this instead:
distinctCountOver(ifelse({has items}='Yes',locations,NULL),[ ], PRE_FILTER)/distinctCountOver(locations,[],PRE_FILTER)

3

Hello @WLS-D , thank you for your answer.
it does not give me error, however I am thinking if this is actually what I want.

I try to explain. I have 100 locations:

80 have items.
I have 5 clients A B C D E that have 20 20 20 10 10 locaiton.

I want to be able to filter for the clients so the total should ont change (thus the Pre_filter is ok) but if I want to select only A B or C, your solution will not work or am I wrong?

4

Hello @remba87

In that instance you could try adding a condition using a parameterized value for your clients.

You can use in() when you have multiple values for a parameter you need to check for: