## 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
is_entity_per_user = self._entity.math == UNIQUE_USERS
        if (
            is_entity_per_user and not self._aggregate_users_by_distinct_id
        ) or self._column_optimizer.is_using_cohort_propertes:
            self._should_join_distinct_ids = True
    def _get_date_filter(self) -> Tuple[str, Dict]:
        date_filter = ""
        query_params: Dict[str, Any] = {}
        query_date_range = QueryDateRange(self._filter, self._team)
        parsed_date_from, date_from_params = query_date_range.date_from
        parsed_date_to, date_to_params = query_date_range.date_to
        query_params.update(date_from_params)
        query_params.update(date_to_params)
        self.parsed_date_from = parsed_date_from
        self.parsed_date_to = parsed_date_to
        if self._entity.math in [WEEKLY_ACTIVE, MONTHLY_ACTIVE]:
            active_user_format_params, active_user_query_params = get_active_user_params(
                self._filter, self._entity, self._team_id
            )
            self.active_user_params = active_user_format_params
            query_params.update(active_user_query_params)
            date_filter = "{parsed_date_from_prev_range} {parsed_date_to}".format(
                **active_user_format_params, parsed_date_to=parsed_date_to
            )
        else:
            date_filter = "{parsed_date_from} {parsed_date_to}".format(
                parsed_date_from=parsed_date_from, parsed_date_to=parsed_date_to
            )
        return date_filter, query_params
    def _get_entity_query(self) -> Tuple[str, Dict]: