6 Replies Latest reply: Oct 7, 2016 1:43 AM by Siddharth Gupta RSS

    I want to calculate per day category wise data

    Siddharth Gupta

      Hello All,

      Stuck in this way menace thing,

       

      I have a excel in which everyday tickets are getting logged, I have to calculate this tickets on per day basis

      ex

      Date               Category

      01-08-2016      Down Call

      01-08-2016      Down Call

      01-08-2016      Down Call

      01-08-2016      Down Call

      02-08-2016      Down Call

      02-08-2016      Down Call@

      02-08-2016      Down Call

      02-08-2016      Down Call

      02-08-2016      Down Call


      Now I have to Calculate on per day like category=''Down Call' and count on single date ex 01 was 4 then adding this with date 02 i.e.

      so total would be 9.

      I will be dividing the end result with the total no. of devices I have, So that I can have a percentage score for performance evaluation on daily basis for a whole month