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
User | Count |
---|---|
2 | |
1 | |
1 | |
1 | |
1 |