I have created a new calculated dimension using 2 dimension in if statement. For example
=IF(TRIP = 12345 AND CURRENCY = 'USD','US','IN'). I used the straight table chart and 2 rows appeared on the chart. I clicked on US on the chart and it filtered for the US row but when I clicked the US again the filter was not removed and the only way I could remove the filter was to use the clear button. Is this a normal behavior or do anyone of you have answer on how to make this work.
Hi, see the attached.
it is not a bad behaviour, if you create the dimension calculated will be behave of that way.
always, if you have the possibility , i recommend creating the calculated dimension (flag using "if") in the script, and the in the object you only have to call them and put as a dimension.
see the attach example, and test now, i think that is the correct use