Hi,
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.
Dimension:
LOAD * INLINE [
_Dimension, _Dimension_Flag
D1,1
D2,2
D3,3
D4,4
D5,5
D6,6
D7,7
D8,8
D9,9
D10,10
D11,11
D12,12
D13,13
];
Metrics:
LOAD * INLINE [
_Metric, _Metric_Flag
x,1
y,2
z,3
a,4
b,5
c,6
d,7
e,8
f,9
g,10
h,11
i,12
];