## Bug description

Monthly Active Users metric seems wrong when choosing "# Number" as chart type.

Number: 
![image](https://user-images.githubusercontent.com/513669/201980874-be7d9c0d-5c9c-4c1e-955c-ea4143c84061.png)

Line chart: 
![image](https://user-images.githubusercontent.com/513669/201980986-b17af929-84e5-4f6a-b7f8-23b7ac8bedbc.png)

**490 != 70**

## How to reproduce

1. Create a new insight using any event and the "Monthly active users" metric
2. Date range = This month + Grouped by = Day
3. Choose chart type as Number => remember value
4. Change chart type as Linear => check last data point

=> the 2 values do not match
=> in other words there's a diff between a total aggregation and an aggregation per bucket of time ?

## Environment

- [x] PostHog Cloud
posthog/queries/test/test_trends.py
set_instance_setting("STRICT_CACHING_TEAMS", "all")
        fake_cached = {"result": [{"days": ["2020-01-02", "2020-01-03", "2020-01-04"], "data": [0.0, 0.0, 0.0]}]}
        filter = Filter(
            data={"date_from": "2020-01-02", "date_to": "2020-01-04", "events": [{"id": "sign up", "name": "sign up"}]},
            team=self.team,
        )
        cache_key = generate_cache_key(f"{filter.toJSON()}_{self.team.pk}")
        cache.set(cache_key, fake_cached, settings.CACHED_RESULTS_TTL)
        res = Trends().get_cached_result(filter, self.team)
        self.assertTrue(res)
        fake_cached = {"result": [{"days": ["2020-01-01", "2020-01-02", "2020-01-03"], "data": [0.0, 0.0, 0.0]}]}
        cache.set(cache_key, fake_cached, settings.CACHED_RESULTS_TTL)
        res = Trends().get_cached_result(filter, self.team)
        self.assertFalse(res)
    def test_get_cached_result_week(self):