## 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
) d
    /* In Postgres we'd be able to do a non-cross join with multiple inequalities (in this case, <= along with >),
       but this is not possible in ClickHouse as of 2022.10 (ASOF JOIN isn't fit for this either). */
    CROSS JOIN (
        SELECT
            toTimeZone(toDateTime(timestamp, 'UTC'), %(timezone)s) AS timestamp,
            {aggregator}
        FROM ({event_query}) events
        WHERE 1 = 1 {parsed_date_from_prev_range} {parsed_date_to}
        GROUP BY timestamp, {aggregator}
    ) e WHERE e.timestamp <= d.timestamp + INTERVAL 1 DAY AND e.timestamp > d.timestamp - INTERVAL {prev_interval}
    GROUP BY d.timestamp
    ORDER BY d.timestamp
) WHERE 1 = 1 {parsed_date_from} {parsed_date_to}
"""
AGGREGATE_SQL = """
SELECT groupArray(day_start) as date, groupArray({aggregate}) as data FROM (
    SELECT {smoothing_operation} AS count, day_start
    from (
        {null_sql}
        UNION ALL
        {content_sql}
    )
    group by day_start
    order by day_start
)
SETTINGS timeout_before_checking_execution_speed = 60
"""
CUMULATIVE_SQL = """
SELECT person_id, min(timestamp) as timestamp