All Collections
Tips & Tricks
TIPS & TRICKS: Average or Sum?
TIPS & TRICKS: Average or Sum?

How longer frequencies display on graphs.

Support avatar
Written by Support
Updated over a week ago

By default, when changing the time frame of a graph from daily to weekly or weekly to monthly, the values are added together. This makes sense when tracking things like sales, income or leads.

However, if you want to track things like Total Number of Staff, Weekly Bank Balance
or Total Number of Clients, then adding values together doesn't make sense. 

For example, let's say you're tracking the weekly Bank Balance, which for the past 4 weeks has the following values:

  • Week 1: $5,000

  • Week 2: $2,000

  • Week 3: $8,000

  • Week 4: $10,000

If you changed the time frame (also called the frequency) to monthly, by default the values will be added together for a total of $25,000. This figure is incorrect because at the end of the month, there isn't $25,000 in the bank, there's only $10,000 because that is the value of the bank balance in the 4th week.

These type of statistics we call Status Statistics. They don't accumulate, they represent the actual value at that specific time.

To view a Status Statistic, use the Average method. 

Using the Bank Balance graph as an example, it can now be viewed across different time frames, as shown below.

For more information, read the blog article When Average Is Better - An Introduction To The Status Statistic.

Did this answer your question?