I have 3 filters/flags as below. There are 4 measures Total Visit, Inventory Support, Price Drop, Demo Validation.
This shows stores visited and other 3 expressions/ modules filled. Flags :
Inventory Flag | Price Drop | Demo Flag |
Y | Y | Y |
N | N | N |
Query : When i select any of the 3 flags i want data to filter out accordingly.
I have created 3 variables:
1. v Inv Flag = get field selection(Inventory Flag) // returns Y or N or null '-'
2. v Price Flag= get field selection(Price Drop)// returns Y or N or null '-'
3.vDemoFlag=get fields election(Demo Flag)// returns Y or N or null '-'
Expressions:
1.Total Visits = count(distinct {<Inventory Flag={'$(v Inv Flag)'}, Price Drop={'$(v Price Flag)'}, Demo Flag={'$(v Demo Flag)'}>}Store code)
Issue: This is not working fine when no inventory flag is selected . i.e v Inv Flag = '-'. Similarly for other 2 flags
I need to add all 3 flags selection in all expressions. User can select any flag and want data of each expression on that basis
2 . Inventory Support = count(distinct {<Inventory Flag={'$(v Inv Flag)'}>}Store code)
3. Price Drop = count(distinct {<Price Drop={'$(v Price Flag)'}>}Store code)
4. Demo Validation = count(distinct {<Demo Flag={'$(v Demo Flag)'}>}Store code)