How to calculate daily average temperature?

[#1]

Dear Qlikview users,

I have a dataset which consist of a hourly logging (per day) of the temperature outside.

I want to create a new temperature field called temperature_per_day which holds the daily temperature value.

How can I achieve this?

I added the dataset as an attachement.

[Gysbert_Wassenaar · Accepted solution]

Best way is to start by splitting the datetime field into date and time fields in the script. Then you can either calculate the average in the script too or only in a chart. See attached example.