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 for the example above, you should use the "Last reported value of the period":
Depending on the scenario, you can use any of the following options:
Sum of all values in the period
Average of all values in the period
Minimum value within the period
Maximum value within the period
First reported value within the period
Last reported value within the period
Using the Bank Balance graph as an example, the Last reported value within the period can now be viewed across different time frames, as shown below.
