## 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
_create_person(team_id=self.team.pk, properties={"email": "foo@example.com", "bar": "aa"}, distinct_ids=["d1"])
        _create_person(team_id=self.team.pk, properties={"email": "bar@example.com", "bar": "bb"}, distinct_ids=["d2"])
        _create_person(team_id=self.team.pk, properties={"email": "efg@example.com", "bar": "ab"}, distinct_ids=["d3"])
        _create_person(team_id=self.team.pk, properties={"bar": "aa"}, distinct_ids=["d4"])
        with freeze_time("2020-01-02 16:34:34"):
            _create_event(team=self.team, event="$pageview", distinct_id="d1")
            _create_event(team=self.team, event="$pageview", distinct_id="d2")
            _create_event(team=self.team, event="$pageview", distinct_id="d3")
            _create_event(team=self.team, event="$pageview", distinct_id="d4")
        event_filtering_action = Action.objects.create(team=self.team, name="$pageview from non-internal")
        ActionStep.objects.create(
            action=event_filtering_action,
            event="$pageview",
            properties=[{"key": "bar", "type": "person", "value": "a", "operator": "icontains"}],
        )
        with freeze_time("2020-01-04T13:01:01Z"):
            response = Trends().run(Filter({"actions": [{"id": event_filtering_action.id}]}), self.team)
        self.assertEqual(len(response), 1)
        self.assertEqual(response[0]["count"], 3)
        with freeze_time("2020-01-04T13:01:01Z"):
            response_with_email_filter = Trends().run(
                Filter(
                    {
                        "actions": [{"id": event_filtering_action.id}],