What's the best way to get a daily average. The data would have 2 values per day, for example:
Date Value
1/1/2012 4:00 10.00
1/1/2012 16:00 11.00
1/2/2012 4:00 11.22
1/2/2012 16:00 13.55
etc.
Select CAST(DateColumn as date), AVG(Value)
From Table
Group By CAST(DateColumn as date)
select date, avg(value)
from yourTable
group by date
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With