Sum of distinct count of an expression traffic light style graph
I am trying to use a traffic light system in chart
So far I have created the graph with the distinct count of the items, i have also created an average count which also works.
But I am looking for help to create a total of the average count of items so that I can change the bar colour to green if it is below the total average, red if it is above total average, otherwise colour it orange.
I have tried many different combinations of avg / aggr/ total but I cannot seem to find the solution.