Averages in weekly event count
- This topic has 0 replies, 1 voice, and was last updated 8 years, 8 months ago by
.
-
Hi there. I can’t figure out why the Averages column is off. I’m generating a weekly event count report for a week which spans a Wednesday to a Wednesday. Obviously the report will generate two partial weeks. Does this affect the averages column or is there a factor I’m missing. The averages per hour just don’t add up. For example if the 000-0100 hour has one event on mon, and one event on tuesday, with no events for the rest of the week, the 1-5 and 1-7 averages show 0.7
In Profile -> Adjust all days for all months have a factor of 1.
Thanks for your time.
UPDATED SOLUTION:
I figured it out. it averages for only the days in which there is data, including zero event days, but excluding days where there is no data. so if monday and tuesday are both 1, wednesday is 0, and the rest are *-no data is will add 1+1+0 and divide by 3.
Thanks
You must be logged in to reply to this topic.