I've created a dynamic report and found a strange behaviour. I've finally managed to see a pattern and don't know if it's a bug or something I've overlooked.
Maybe someone here can shed some light on this
I'm loading inline tables and using the expressions in conditional to show/hide:
Dimensions: =SubStringCount(Concat(_Dimension_Flag, '|'), '1') and so on
Metrics: =SubStringCount(Concat(_Metric_Flag, '|'), '1') and so on
But whenever i use the selection box for a value that is over 9 the dimension or metric with the first corresponding number is also shown.
If I choose Dimension 10, Dimension 1 is also shown.
If I choose Dimension 13, Dimension 3 is also shown
If I choose Metric 11, Metric 1 is also shown
If I choose Metric 12, Metric 2 is also shown
Loading the data islands for the selections like this.