16 Replies Latest reply: Jul 30, 2018 3:32 AM by sagar jagga RSS

    Bar chart creation using particular fields from dimensions

    sagar jagga

      Hi All,

       

      I am facing a challenge to create a bar chart using 2 dimensions for below data set.

       

         

      ManagerSupervisior                                                     PAT Roll No
      AnindyaABC1
      AnindyaABC11
      AnindyaABC22
      AnindyaABC33
      AnindyaDEF10
      AnindyaDEF10
      MehtabABC33
      MehtabFED44
      SagarABC21
      SagarFED33

       

       

      I need to create bar chart only for Anindya and sagar who are under manager and for supervisiors ABC,FED and bar chart should be 'grouped bar chart' and it should show share of count of 'PAT Roll No' under supervisior and manager dimension in respective bars. for example count of PAT roll no in Anindya in ABC and FED is 4(as there is no FED for anindya) so ABC bar chart will show 100%(4/4) and for FED it will be 0%

      Then for sagar count of pat roll no under ABC and FED is 2(1+1) so 50% for ABC bar(1/2) and 50% for FED bar(1/2)


      Thanks,