Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
Time | Temp |
10:05:00 | 49 |
10:10:00 | 44 |
10:15:00 | 43 |
10:20:00 | 46 |
10:25:00 | 45 |
10:30:00 | 40 |
10:35:00 | 50 |
10:40:00 | 42 |
10:45:00 | 43 |
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:
Time | Temperature (Degree) |
10:05 | 45.50 |
10:25 | 44.25 |
10:45 | 45.50 |
Hi Anand,
may be
Temp:
LOAD *,Autonumber(Floor((RowNo()-1)/4)) as A1 Inline [
Time Temp
10:05:00 49
10:10:00 44
10:15:00 43
10:20:00 46
10:25:00 45
10:30:00 40
10:35:00 50
10:40:00 42
10:45:00 43
](delimiter is spaces);
LOAD Time(Min(Time)) as Time,Avg(Temp) as Temp
Resident Temp
Group By A1;
Drop Table Temp;
Regards,
Antonio
Apologies for coming back late on this. Thanks you very much Antonio. this was very very helpful.