9 Replies Latest reply: Dec 9, 2011 2:10 AM by Aissam Boumejjane RSS

    creating 100% grouped bar per country

    Aissam Boumejjane

      Hi guys,


      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.