## 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
sign_up_action, person = self._create_events()
        action_response = Trends().run(Filter(data={"actions": [{"id": sign_up_action.id}]}), self.team)
        event_response = Trends().run(Filter(data={"events": [{"id": "sign up"}]}), self.team)
        self.assertEqual(len(action_response), 1)
        self.assertEntityResponseEqual(action_response, event_response)
    def test_trends_for_non_existing_action(self):
        with freeze_time("2020-01-04"):
            response = Trends().run(Filter(data={"actions": [{"id": 50000000}]}), self.team)
        self.assertEqual(len(response), 0)
        with freeze_time("2020-01-04"):
            response = Trends().run(Filter(data={"events": [{"id": "DNE"}]}), self.team)
        self.assertEqual(response[0]["data"], [0, 0, 0, 0, 0, 0, 0, 0])
    @test_with_materialized_columns(person_properties=["email", "bar"])
    def test_trends_regression_filtering_by_action_with_person_properties(self):