4 Replies Latest reply on Jul 5, 2018 11:22 PM by Ahamed Basha

    Team, I have to total difference of Employee count in a bar chart

    Ahamed Basha

      Team,

       

      I have to calculate the Head count difference at the end of the bar chart like this.

       

      I have to show total count in the end of the bar chart respectively for each location and with the corresponding month.

      Data:

       

      Current
        Year
      Report MonthLocationMetricsEmployee countTotal Hc
      2018MayEGS IndiaTotal HC14664
      2018MayEGS IndiaCTR Count1695
      2018MayEGS IndiaNight Shift Count1567
      2018MayEGS IndiaMisc301
      2018MayEGS IndiaInterns01110114664 - 1695 - 1567 -301 = 11101
      2018MayWFC-BangaloreTotal HC6784
      2018MayWFC-BangaloreCTR Count953
      2018MayWFC-BangaloreNight Shift Count518
      2018MayWFC-BangaloreMisc136
      2018MayWFC-BangaloreInterns051776784 - 953 - 518 - 136 = 5177
      2018MayWFC-HyderabadTotal HC7335
      2018MayWFC-HyderabadCTR Count706
      2018MayWFC-HyderabadNight Shift Count788
      2018MayWFC-HyderabadMisc162
      2018MayWFC-HyderabadInterns056797335-706-788-162 = 5679
      2018MayWFC-ChennaiTotal HC545
      2018MayWFC-ChennaiCTR Count36
      2018MayWFC-ChennaiNight Shift Count261
      2018MayWFC-ChennaiMisc3
      2018MayWFC-ChennaiInterns0245545-36-261-3 = 245

       

      Message was edited by: Ahamed Basha