Forum Discussion
Khalil_Ammar
Aug 06, 2023Copper Contributor
summarizing sensor Hourly Data to daily data
I have for each daily date hourly data in the same cell, i.e., the cell contains the date and hour. I am interested in calculating the average daily value from the hourly soil moisture sensor values....
SergeiBaklan
Aug 07, 2023Diamond Contributor
Khalil_Ammar
Another option for averaging is PivotTable with grouping datetime as desired
Khalil_Ammar
Aug 07, 2023Copper Contributor
Thank you very much, Sergie. This was very helpful.