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:

      CountryCode

      Status

       

      My expression is: count(shipmentid) / count(Total shipmentid)

       

      Thanks in advance!

       

      Isam

       

      I've attached a screenshot with what I'm trying to achieve.

       

      Regards,

       

      iSam