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!