I have a report that uses a line graph to calculate the average number of days to process a case per month. The problem is it appears to only be calculating this if it has three or more variables (closed cases) in that month.
1) a query locates all cases which have been finished (query name: ClosedCases) and includes a column that calculates the number of days it took to close the case (Case closed date - Case open date). Column is labeled "Expr1"
2) the report uses the query (ClosedCases) to display a line graph of the average number of days it takes to complete a case per month.
3) the graph calculates the average in the report: Avg([Expr1]) AS [AvgOfExpr1] FROM [ClosedCases]
I need it to calculate the average number of days to complete the case even if that month only has 1 or two closed cases.
How do I get it to calculate the average with only two variables? TIA.