## 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
{actions_query}
"""
BREAKDOWN_COHORT_JOIN_SQL = """
INNER JOIN (
    {cohort_queries}
) ep
ON e.distinct_id = ep.distinct_id where team_id = %(team_id)s {event_filter} {filters} {parsed_date_from} {parsed_date_to} {actions_query} {null_person_filter}
"""
_LIFECYCLE_EVENTS_QUERY = """
SELECT
    person_id,
    /*
        We want to put the status of each period onto it's own line, so we
        can easily aggregate over them. With the inner query we end up with a structure like:
        person_id  |  period_of_activity  | status_of_activity  | dormant_status_of_period_after_activity
        However, we want to have something of the format:
        person_id  | period_of_activity          |  status_of_activity
        person_id  | period_just_after_activity  |  dormant_status_of_period_after_activity
        such that we can simply aggregate over person_id, period.
    */
    arrayJoin(
        arrayZip(
            [period, period + INTERVAL 1 {interval_expr}],
            [initial_status, if(next_is_active, '', 'dormant')]
        )
    ) AS period_status_pairs,
    period_status_pairs.1 as start_of_period,
    period_status_pairs.2 as status
FROM (
    SELECT