Calculating average number of users per month

[rimshasajid30]

I have calculated my months using the following formula
(DATE_DIFF(MAX(Date),MIN(Date)) +1)/30 
and now I want to calculate average users per month by the following formula but I always get an incorrect answer
Total users/Number of Months

[sam8]

That's strange! Can you share the formula for the average users per month? A simple division like that really should return the correct answer, there must be something else we're missing.

[rimshasajid30]

For Average Users per month I use, Total Users / Number of Months

[rimshasajid30]

Will it be helpful if I share my sheet link with you?

[Mehdi_Oudjida]

@rimshasajid30 ,

It is probably not a problem of formula but more about date ranges. You should check which date range is configured for each chart.

Maybe you hard configured a specific date range for some scorecards and let the automatic date range from the date picker for others.

The 2nd sanity check for the top 2 usual suspect is about the chart filters, but less likely. 

Mehdi

[rimshasajid30]

Hi Mehdi

My dates are set to auto so there is no issue over there.