## 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(len(response), 1)
        self.assertEqual(response[0]["breakdown_value"], "test@gmail.com")
    @snapshot_clickhouse_queries
    @test_with_materialized_columns(event_properties=["key"], person_properties=["email", "$os", "$browser"])
    def test_trend_breakdown_user_props_with_filter_with_partial_property_pushdowns(self):
        _create_person(
            team_id=self.team.pk,
            distinct_ids=["person1"],
            properties={"email": "test@posthog.com", "$os": "ios", "$browser": "chrome"},
        )
        _create_person(
            team_id=self.team.pk,
            distinct_ids=["person2"],
            properties={"email": "test@gmail.com", "$os": "ios", "$browser": "safari"},
        )
        _create_person(
            team_id=self.team.pk,
            distinct_ids=["person3"],
            properties={"email": "test2@posthog.com", "$os": "android", "$browser": "chrome"},
        )
        # 
        _create_person(
            team_id=self.team.pk,
            distinct_ids=["person32"],
            properties={"email": "test2@posthog.com", "$os": "android", "$browser": "chrome"},