Our full technical support staff does not monitor this forum. If you need assistance from a member of our staff, please submit your question from the Ask a Question page.


Log in or register to post/reply in the forum.

Create a monthy by date average data file with split, averaging the data from a 60 minute data table for the same month


IslandMan Aug 19, 2022 03:12 PM

Hello,

I want to create a monthy average data table, by day, using the data from a 60 minute data table for the month and I can't seem to get it to work.

Start Condition 1[2022]:1[5%1]:1:

Stop Condition 1[2022]:1[5%5]::

edate("yyyy mm dd";1;1;1),edate("hh nn";1;1),Avg(4;24)
4 = the 60 minute average Wind Speed

Trying to start out simple and when I get it working, do the entire data string.

I wind up with this:
2022 05 01 00 00
2022 05 01 01 00
2022 05 01 02 00
2022 05 01 03 00
2022 05 01 04 00
2022 05 01 05 00
2022 05 01 06 00
2022 05 01 07 00
2022 05 01 08 00
2022 05 01 09 00
2022 05 01 10 00
2022 05 01 11 00
2022 05 01 12 00
2022 05 01 13 00
2022 05 01 14 00
2022 05 01 15 00
2022 05 01 16 00
2022 05 01 17 00
2022 05 01 18 00
2022 05 01 19 00
2022 05 01 20 00
2022 05 01 21 00
2022 05 01 22 00
2022 05 01 23 00 5.7

Thanks,
Dave

Log in or register to post/reply in the forum.