## 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
person_id,
        period,
        created_at,
        if(
            dateTrunc(%(interval)s, toTimeZone(toDateTime(created_at, 'UTC'), %(timezone)s)) = period,
            'new',
            if(
                previous_activity + INTERVAL 1 {interval_expr} = period,
                'returning',
                'resurrecting'
            )
        ) AS initial_status,
        period + INTERVAL 1 {interval_expr} = following_activity AS next_is_active,
        previous_activity,
        following_activity
    FROM (
        SELECT
            person_id,
            any(period) OVER (PARTITION BY person_id ORDER BY period ROWS BETWEEN 1 PRECEDING AND 1 PRECEDING) as previous_activity,
            period,
            any(period) OVER (PARTITION BY person_id ORDER BY period ROWS BETWEEN 1 FOLLOWING AND 1 FOLLOWING) as following_activity,
            created_at
        FROM ({events_query})
    )
)
WHERE period_status_pairs.2 != ''
"""
LIFECYCLE_SQL = f"""
WITH
    %(interval)s AS selected_period,