## 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
with freeze_time("2020-01-12T09:01:01Z"):
            _create_event(
                team=self.team,
                event="sign up",
                distinct_id="blabla",
                properties={"$current_url": "first url", "$browser": "Firefox", "$os": "Mac"},
            )
        with freeze_time("2020-01-22T01:01:01Z"):
            _create_event(
                team=self.team,
                event="sign up",
                distinct_id="blabla",
                properties={"$current_url": "second url", "$browser": "Firefox", "$os": "Mac"},
            )
        #  
        with freeze_time("2020-01-26T07:00:00Z"):  # th
            response = Trends().run(
                Filter(
                    data={
                        "date_from": "-14d",
                        "interval": "week",
                        "events": [{"id": "sign up", "name": "sign up"}],
                    },
                    team=self.team,
                ),
                self.team,
            )
        self.assertEqual(response[0]["data"], [1.0, 1.0, 1.0])
        self.assertEqual(response[0]["labels"], ["5-Jan-2020", "12-Jan-2020", "19-Jan-2020"])
    def test_same_day(self):