I´m using a pie chart to illustrate vacancy in properties. To do this I´m using a calculated dimension:
if(Match(CONTRACTS, 'Vacant'), 'Vacant', 'Rented')
- Everything works fine except that when clicking on Rented in the pie chart I can see the contracts but I cant click myself back by clicking on the chart again. Which makes me unable to see the vacancy again.
How can this be fixed?