Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Has anybody tried to substract choices from alternate state from data set original set?
Lets assume we have a filter field called Value, on which we have assigned AlternateState1. I would like to show values remaining in the value set after user choses Values assigned to AlternateState1:
count(Value)-count({[AlternateState1]}Value)
However, when I visualize results in a new table (alternate state:default) , amount is not being substracted at all.
Would be grateful for any suggestions where to look next, as apparently this alternate state identifier in the set expression is not working properly.
count(all Value)-count({[AlternateState1]}Value)
Thank you for the response, the result does not change either. I have also tried
COUNT({1 - AlternateState1} [VALUE])
But the new table does not reflect results at all - when I chose a Value in AlternateState1, values in tables remain unchanged. Could it be some issue with Alternate States itself? I have assigned them to filters by Apperance - > State-> AlternateState1.