## 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
),
                self.team,
            )
            event_response = Trends().run(
                Filter(
                    data={
                        "date_from": "-14d",
                        "breakdown": json.dumps([cohort.pk, cohort2.pk, cohort3.pk, "all"]),
                        "breakdown_type": "cohort",
                        "events": [{"id": "watched movie", "name": "watched movie", "type": "events", "order": 0}],
                    }
                ),
                self.team,
            )
        counts = {}
        break_val = {}
        for res in event_response:
            counts[res["label"]] = sum(res["data"])
            break_val[res["label"]] = res["breakdown_value"]
        self.assertEqual(counts["watched movie - cohort1"], 1)
        self.assertEqual(counts["watched movie - cohort2"], 3)
        self.assertEqual(counts["watched movie - cohort3"], 4)
        self.assertEqual(counts["watched movie - all users"], 7)
        self.assertEqual(break_val["watched movie - cohort1"], cohort.pk)
        self.assertEqual(break_val["watched movie - cohort2"], cohort2.pk)
        self.assertEqual(break_val["watched movie - cohort3"], cohort3.pk)
        self.assertEqual(break_val["watched movie - all users"], "all")
        self.assertEntityResponseEqual(event_response, action_response)
    @test_with_materialized_columns(verify_no_jsonextract=False)
    def test_interval_filtering_breakdown(self):