## 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
),
            self.team,
        )
        self.assertEqual(response[0]["data"][17], 1)
        self.assertEqual(len(response[0]["data"]), 24)
        # C
        response = Trends().run(
            Filter(
                data={
                    "date_from": "2020-01-03",
                    "date_to": "2020-01-03",
                    "events": [{"id": "sign up", "name": "sign up"}],
                },
                team=self.team,
            ),
            self.team,
        )
        self.assertEqual(response[0]["data"], [1.0])
    @snapshot_clickhouse_queries
    def test_timezone_weekly(self):
        self.team.timezone = "US/Pacific"
        self.team.save()
        _create_person(team_id=self.team.pk, distinct_ids=["blabla"], properties={})
        with freeze_time("2020-01-12T02:01:01Z"):
            _create_event(
                team=self.team,
                event="sign up",
                distinct_id="blabla",
                properties={"$current_url": "first url", "$browser": "Firefox", "$os": "Mac"},
            )