I have a bar chart that give the percentage of shipments that are ontime or late per country.
the bar chart calculates the percentage of ontime/late based on all the countrycodes in the bar chart. Only when I click on a certain country e.g. 'AE' I see the the 'total percentage' of a specific country.
Is there a way to do this for all the country, without having to click on a certain country?
I have 2 dimensions:
My expression is: count(shipmentid) / count(Total shipmentid)
Thanks in advance!
I've attached a screenshot with what I'm trying to achieve.