## 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
-- enumerate all requested periods, so we can zero fill as needed.
    -- NOTE: we use dateSub interval rather than seconds, which means we can handle,
    -- for instance, month intervals which do not have a fixed number of seconds.
    periods AS (
        SELECT dateSub(
            {{interval_expr}},
            number,
            dateTrunc(selected_period, toDateTime(%(date_to)s, %(timezone)s))
        ) AS start_of_period
        FROM numbers(
            dateDiff(
                %(interval)s,
                dateTrunc(%(interval)s, toDateTime(%(date_from)s, %(timezone)s)),
                dateTrunc(%(interval)s, toDateTime(%(date_to)s, %(timezone)s) + INTERVAL 1 {{interval_expr}})
            )
        )
    )
SELECT
    groupArray(start_of_period) as date,
    groupArray(counts) as data,
    status
FROM (
    SELECT if(
            status = 'dormant',
            toInt64(SUM(counts)) * toInt16(-1),
            toInt64(SUM(counts))
        ) as counts,
        start_of_period,
        status
    FROM (