I'm using a calculated dimension for one of my charts in a mashup, but when a selection is made by clicking directly on the lines, the resulting tag in the selections bar shows the dimension formula instead of the actual dimension. For the screenshot below, the dimensions is:
Where Growth MonthYear Label is simply a text representation of the date Growth MonthYear. As you can see, there are already a few [Growth MonthYear Label] values filtered. I'd expect when a selection is made through the chart, the filtered [Growth MonthYear Label] values should change instead of having a new dimension value appear.
I've tried using Master Items, visualizations created on the fly, master dimensions and "regular" dimensions. Note that the problem is the same in the application and in the mashup.
The only way I've managed to get the desired result is by using a regular dimension, adding a conditional statement to my measure, and unchecking the checkbox in Add-ons > Data handling > Include zero values. This option, however, is not available for Filter pane objects (obviously) or for chart visualizations created on the fly, which is what I need.