Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I have a problem with a bar chart with a dimension and a calculated dimension as a second dimension. The 1st dimension is a group of 6 different fields and the calculated dimension shows how many objects that are below or above a certain threshold. The chart is working but I am trying to show the percentage for each field in the first dimension that has above/below (compared to it self). I have tried to use count(distinct VIN)/count(Total distinct VIN) but it is not working. In my attached example I have 2 charts with calculated dimension and 2 charts with expression instead. So basically the calculated dimension chart should look the same as the regular expression chart.
Any input is much appreciated!
Br
Patrik
This expression seems to work for some of the fields :RangeSum(ABOVE(aggr(count( DISTINCT VIN),IUPRGroup),0,2))
but not for all