2 Replies Latest reply: Jul 4, 2017 11:41 AM by Anand Gangwar RSS

    Aggregating data on

    Anand Gangwar

      Dear All,

       

      I am looking to calculate average temperature data based on the attached data series. What I have is 2 columns - one with time, other with Temperature (for every 5 minutes). The data is something like below:

         

      TimeTemp
      10:05:0049
      10:10:0044
      10:15:0043
      10:20:0046
      10:25:0045
      10:30:0040
      10:35:0050
      10:40:0042
      10:45:0043

       

       

       

      I have uploaded this data in the Qlikview directly from a website API. as per the second step, I would want to get average temperature for 4 time periods as below:

         

      TimeTemperature (Degree)
      10:05

      45.50

       

      10:2544.25
      10:45

      45.50