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.
[Solved] Daily average of hourly data
[Solved] Daily average of hourly data
Last edited by Hagar Delest on Mon May 14, 2018 9:32 pm, edited 1 time in total.
Reason: tagged [Solved].
Reason: tagged [Solved].
Apache OpenOffice 4.1.3 on Windows 10
Re: Daily average of hourly data
- Are there timestamp values for each temperature data in your file?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?
- Where (how) are stored the temperature values? (In a single column, or in more columns?)
- Can you upload an ODF type sample file here?
Tibor Kovacs, Hungary; LO7.5.8 /Win7-10 x64Prof.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
PortableApps/winPenPack: LO3.3.0-7.6.2;AOO4.1.14
Please, edit the initial post in the topic: add the word [Solved] at the beginning of the subject line - if your problem has been solved.
Re: Daily average of hourly data
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, daysand 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
menu:Data>Pivot Table>Create...
Create from current selection
Drag the date-time stamps or separate dates
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
In case of separate dates and times
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
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Re: Daily average of hourly data
Thanks guys, Villeroy's suggestion works perfectly!
Apache OpenOffice 4.1.3 on Windows 10