[Solved] Daily average of hourly data

[tenrai]

Hello,
I have hourly temperature data for a year that I'd like to reduce into 365 daily average values, without having to make them all manually. Any ideas?
Greatly appreciated.

[Zizi64]

I have hourly temperature data for a year that I'd like to reduce into 365 daily average values, without having to make them all manually. Any ideas?

- Are there timestamp values for each temperature data in your file?
- Where (how) are stored the temperature values? (In a single column, or in more columns?)
- Can you upload an ODF type sample file here?

[Villeroy]

With the cell cursor in the list and column headers in the first row of the list,
menu:Data>Pivot Table>Create...
Create from current selection
Drag the date-time stamps or separate datesand times to [Row Fields]
In case of separate dates and times, use only the dates.

Drag the values to be averaged to [Data Fields]
Double-click and change "Sum" to "Average"
[More Options]
Specify "New Sheet" as output range.
[OK]

Go to the sheet with the pivot table and click a time cell in the row field.
menu:Data>Group>Group [F12]
Group the date-time field by years, months, days and hours
In case of separate dates and times, group the time field by hours.

When the data on the source sheet changed, click any cell in the pivot table and call the Refresh command from context menu or from Data>Pivot Table
Documentation on pivot tables (aka data pilots): https://wiki.openoffice.org/wiki/Docume ... /DataPilot

[tenrai]

Thanks guys, Villeroy's suggestion works perfectly!