3 Replies Latest reply: Jan 12, 2017 3:43 AM by Marcus Sommer RSS

    I want to get Avg of a Ticket on every day basis.

    Siddharth Gupta

      Hello All,


      I am stuck in this whole excel complexity.How I am going to Integrate on Qliksense???

       

      I want to load an Excel file every day as Tickets are getting registered everyday what the management wants is getting Average of tickets which are having category 'Down call'.

       

      What issue I am facing is how I am going to add everyday avg into previous day and taking out the average of all days passed in that month.

       

       

      DateTotal TicketFormula applied:-"100-(Total Tickets/13700)*100= UPTIME%"

      My main Problem!!!

      How to make this work?

      FINAL
      01-01-2016211884.54014599avg(e2)=84.54014599
      02-01-2016239882.49635036avg(e2+e3)=83.51824818
      03-01-2016247681.9270073avg(e2+e3+e4)=82.98783455
      04-01-2016284379.24817518avg(e2+e3+e4+e5)=82.05291971
      05-01-2016293278.59854015avg(e2+e3+e4+e5+e6)=81.3620438

       

      #Color coded for better understanding.

       

      The Final Value will be most important as an KPI whenever the dashboard is opened as UPTIME% will be displayed according to that particular date adding and carrying out average of all previous date and current day.

       

       

      Attaching the main excel for easy understanding.

      Important Column: Category=Down Call, Actual Logged Date, Status=Open and Paused

       

       

      Please Help me in understanding how this problem can be resolved.

       

      Regards,

      Siddharth Gupta

      siddharthgupta2792@gmail.com    

      +919930401207.