2 Replies Latest reply: Sep 14, 2018 4:03 PM by Marco Wedel RSS

    100% stacked bar chart

    Vic Obi

      Hi All, i'm struggling to create a 100% stacked bar chart. I have a stacked chart but it doesn't add up to 100%. Please i need help.


       

      My dimension is: If(WildMatch(Product,'Gold','Silver','Bronze'), Product,Null())

       

       

      and my measure is:

       

       

      sum(

      {$

      <

              Product={'Gold','Silver','Bronze'},

              HousePK=P({1<Product={'Remote'}>}HousePK)>}

      HouseCount)

      /

      sum(total<HousePK>

      {$

      <      Product={'Gold','Silver','Bronze'},

              HousePK=P({1<Product={'Remote','Featured Employer','Featured House','Man of the Week','Sponsored House','Spotlight Ad','Spotlight','Mobile '}>}HousePK)

      >

      }

      HouseCount)


      the above set analysis is just one of the measures against all the product listed and it's adding up to 150% and that's not what i'm looking for.


      I want to create a stacked bar chart where it's showing a subset of all the records in the Product field (Product={'Remote','Featured Employer','Featured House','Man of the Week','Sponsored House','Spotlight Ad','Spotlight','Mobile '}) to reach the total of 100%. I hope i'm making sense