## 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/person_query.py
if self._cohort:
            cohort_table = (
                GET_STATIC_COHORTPEOPLE_BY_COHORT_ID if self._cohort.is_static else GET_COHORTPEOPLE_BY_COHORT_ID
            )
            return (
                f"""
            INNER JOIN (
                {cohort_table}
            ) {self.COHORT_TABLE_ALIAS}
            ON {self.COHORT_TABLE_ALIAS}.person_id = person.id
            """,
                {"team_id": self._team_id, "cohort_id": self._cohort.pk},
            )
        else:
            return "", {}
    def _get_limit_offset(self) -> Tuple[str, Dict]:
        if not isinstance(self._filter, Filter):
            return "", {}
        if not (self._filter.limit or self._filter.offset):
            return "", {}
        clause = ""
        params = {}
        if self._filter.limit:
            clause += " LIMIT %(limit)s"
            params.update({"limit": self._filter.limit})
        if self._filter.offset:
            clause += " OFFSET %(offset)s"
            params.update({"offset": self._filter.offset})
        return clause, params
    def _get_search_clause(self, prepend: str = "") -> Tuple[str, Dict]: