Don't include the current month in the 'Average' and 'Total' in Recurring Series (edited)
Hi
When I click the "View Series" button, it appears the 6-month average and total include the current month, as well as the expected amount if no transactions have been assigned to the series in the current month.
For example, I was viewing my electric-bill series before the bill for the current month came in. It showed an average of $280 and total of $1,682, and I could see the current month in the bar plot. Then I edited the series to increase the monthly expected bill which caused the average to change to $301 and the total to $1,807.
I expect those statistics to be based on only historical transactions that have actually occurred. I don't see the utility in having the average and total be a mixture of historical amounts and the expected amounts for the current month. Showing the statistics for the last 6 months, not including the current month, would give a summary of how things went in the past so I can decide whether/how to change my behavior going forward.
To be clear, I really like the feature, so I don't have to manually configure a report to see a quick summary of the series. I just think the calculation needs to be tweaked to provide the information I'd expect most people want in this situation.
Note that this change also wouldn't prevent me from being able to get this information. I could configure a report to show the average and/or total up to even the current day, and I could even incorporate expected amounts by adding to the total from the report and dividing by the appropriate number of months.
Happy to discuss.
P.S. The same issue of including the current partial month in calculations of statistics appears elsewhere in the product, with requests open to change it in those other places as well.
P.P.S. I'm reposting this after originally creating a discussion under the "Report a Bug" category.