1 Reply Latest reply: Nov 2, 2016 9:41 AM by Patrik Lindegårdh RSS

    Total qualifier with calculated dimension

    Patrik Lindegårdh

      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