## 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/trends/sql.py
)
"""
BREAKDOWN_QUERY_SQL = """
SELECT groupArray(day_start) as date, groupArray(count) as data, breakdown_value FROM (
    SELECT SUM(total) as count, day_start, breakdown_value FROM (
        SELECT * FROM (
            -- Create a table with 1 row for each interval for the requested date range
            -- This acts as a method of zero filling, i.e. when there are no data points
            -- for a given interval, we'll still have a row for the group by interval with
            -- a 0 value.
            --
            -- It's essentially a cross product of graph "ticks" and breakdown values.
            --
            -- TODO: we're relying on num_intervals, seconds_int_interval etc. being passed
            --       in as a parameter. To reduce the coupling between here and the
            --       calling code, we could perform calculations for these within the query
            --       itself based on date_to/date_from. We could also pass in the intervals
            --       explicitly, although we'll be relying on the date handling between python
            --       and ClickHouse to be the same.
            --
            -- NOTE: there is the ORDER BY ... WITH FILL Expression but I'm not sure how we'd
            --       handle the edge cases:
            --
            --          https://clickhouse.com/docs/en/sql-reference/statements/select/order-by/#orderby-with-fill
            --
            SELECT
                toUInt16(0) AS total,
                ticks.day_start as day_start,
                breakdown_value
            FROM (