4 Replies Latest reply on Apr 17, 2014 2:08 PM by James Eichinger

    Monthly Averages not including months with zero activity.

    James Eichinger

      I'm using a trend line to show the average monthly activity in a year. The bar chart shows the count of activity every month. In some cases there is no monthly activity. I was expecting the average to count each month regardless of activity or now. However, that isn't the case. If there is no activity in the month, the month is not counted towards the average. This is a bit of a problem as people without activity should have a lower monthly average than they are currently showing! It makes it very difficult to do projections too! Any work arounds?