## 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
-- Generates all the intervals/ticks in the date range
                -- NOTE: we build this range by including successive intervals back from the
                --       upper bound, then including the lower bound in the query also.
                SELECT
                    {interval}(
                        toDateTime(%(date_to)s, %(timezone)s) - number * %(seconds_in_interval)s
                    ) as day_start
                FROM numbers({num_intervals})
                UNION ALL
                SELECT {interval}(toDateTime(%(date_from)s, %(timezone)s)) as day_start
            ) as ticks
            -- Zero fill for all values for the specified breakdown
            CROSS JOIN
                (
                    SELECT breakdown_value
                    FROM (
                        SELECT %(values)s as breakdown_value
                    ) ARRAY JOIN breakdown_value
                ) as sec
            ORDER BY breakdown_value, day_start
            UNION ALL
            {inner_sql}
        )
    )
    GROUP BY day_start, breakdown_value
    ORDER BY breakdown_value, day_start
)
GROUP BY breakdown_value
ORDER BY breakdown_value
"""