Averages in weekly event count

This topic contains 0 replies, has 1 voice, and was last updated by  jkelly 2 years, 9 months ago.

Viewing 1 post (of 1 total)
  • Author
    Posts
  • #1750

    jkelly
    Participant

    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

    • This topic was modified 2 years, 9 months ago by Metro Admin Metro Admin.
    • This topic was modified 2 years, 9 months ago by Metro Admin Metro Admin.
Viewing 1 post (of 1 total)

You must be logged in to reply to this topic.