Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I have text box using variable : 'vOrder_Volume' , I have multiple filters in my dashboard Like Country, zone, branch, Code etc. But I want to keep this affected by only Branch and below level selection and ignore all above level (Zone, Country) selection , How to make set analysis expression or Is there any other way to achieve that ?Can anyone please help me with that?
Thanks
May be try like this..
Count({<Country, zone, Code>}FieldA)
This will ignore selections on Country, zone and Code.
What you are trying to achieve is not entirely clear, however, if you want to use a user input variable to control what selections are ignored in an expression, then you could try something like:
Sum({<$(vIgnoreSelections)>} Amount)
Where vIgnoreSelections has been set to equal Zone, Country (or what other selections you want to be ignored)
Let vIgnoreSelections = 'Zone, Country'; //in the script
You can add vIgnoreSelection to an Input Box object so users can type fields to ignore, but they must be careful to type it exactly correct.