Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a chart displaying 4 dimensions and 1 expression. The users want a slider to select top/bottom x% of the data.
I have tried to do this but it only seems to work if i have 1 dimension. as soon as i add dimensions it doesnt seem to work correctly
Basically there are 913 rows of available data, if i select 50% from the slider i would expect to see 456 rows in the chart.
The chart with 1 expression is correct - 456 Rows
The chart with all expressions is incorrect - 467 Rows.
I have attached a sample qvw, can anyone see if i am missing something please?
well what happen when you have more then one dimension
is that you get only 50% precent of the first dimension
but then you get all the possbilits with the other dimensions
attach is a file where i created a calculated dimension that built from all 4 dimensions
when you filter this dimension the filter works