List:General Discussion« Previous MessageNext Message »
From:Brian Dunning Date:March 18 2010 6:30pm
Subject:Re: 7-day average
View as plain text  
You're exactly right, that's an important point that I neglected when putting together my
example. Good catch.

On Mar 18, 2010, at 11:27 AM, Chris W wrote:

> I think I would change the math.  Since there are several days in there where there
> are no hits, that should in my opinion count against the average.  So instead of dividing
> by count(h.AccountID),  I would divide by 7 which would change the values to about...
7-day averageBrian Dunning18 Mar
  • Re: 7-day averageJigal van Hemert18 Mar
  • Re: 7-day averageChris W18 Mar
    • Re: 7-day averageBrian Dunning18 Mar