## 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/trends_event_query.py
if self._should_join_sessions
                else ""
            )
            + (
                f", {self.SESSION_TABLE_ALIAS}.$session_id as $session_id"
                if self._should_join_sessions
                and "$session_id" not in self._extra_event_properties
                and "$session_id" not in self._column_optimizer.event_columns_to_query
                else ""
            )
            + (f", {self.EVENT_TABLE_ALIAS}.distinct_id as distinct_id" if self._aggregate_users_by_distinct_id else "")
            + (f", {self.EVENT_TABLE_ALIAS}.person_id as person_id" if self._using_person_on_events else "")
            + (
                " ".join(
                    f", {self.EVENT_TABLE_ALIAS}.{column_name} as {column_name}" for column_name in self._extra_fields
                )
            )
            + (self._get_extra_person_columns())
        )
        if self._using_person_on_events:
            for column_name in sorted(self._column_optimizer.person_on_event_columns_to_query):
                _fields += f', {self.EVENT_TABLE_ALIAS}."{column_name}" as "{column_name}"'
        if self._using_person_on_events and groups_on_events_querying_enabled():
            for column_name in sorted(self._column_optimizer.group_on_event_columns_to_query):
                _fields += f', {self.EVENT_TABLE_ALIAS}."{column_name}" as "{column_name}"'
        date_query, date_params = self._get_date_filter()
        self.params.update(date_params)
        prop_query, prop_params = self._get_prop_groups(
            self._filter.property_groups.combine_property_group(PropertyOperatorType.AND, self._entity.property_groups),
            person_properties_mode=PersonPropertiesMode.DIRECT_ON_EVENTS