## Bug description

When calculating Trends results with an aggregated (e.g. single output, like big number) display type, WAU/MAU don't work. This is because we have an `ACTIVE_USERS_SQL` query for time series display types, but we don't have a version of this for aggregated display types. (See ZEN-1043.)

## How to reproduce

1. Create an insight with a single WAU or MAU series.
2. Switch display type to "Number".
3. Open the "Debug ClickHouse queries" modal from the command palette.
4. See `COUNT(*)` instead of `COUNT(DISTINCT person_id)`.

#### *Thank you* for your bug report – we love squashing them!

posthog/queries/test/test_trends.py
_create_person(team_id=self.team.pk, distinct_ids=["person_1"], properties={"name": "John"})
        for time in dates:
            with freeze_time(time):
                _create_event(
                    event="event_name", team=self.team, distinct_id="person_1", properties={"$browser": "Safari"}
                )
        if query_time:
            with freeze_time(query_time):
                response = Trends().run(Filter(data={**filter_params, "events": [{"id": "event_name"}]}), self.team)
        else:
            response = Trends().run(Filter(data={**filter_params, "events": [{"id": "event_name"}]}), self.team)
        self.assertEqual(result[0]["count"], response[0]["count"])
        self.assertEqual(result[0]["labels"], response[0]["labels"])
        self.assertEqual(result[0]["data"], response[0]["data"])
        self.assertEqual(result[0]["days"], response[0]["days"])
    def test_hour_interval(self):