## 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/breakdown_props.py
entity = kwargs.pop("entity", None)
    date_params = {}
    query_date_range = QueryDateRange(filter=filter, team=team, table="all_events", should_round=False)
    parsed_date_from, date_from_params = query_date_range.date_from
    parsed_date_to, date_to_params = query_date_range.date_to
    date_params.update(date_from_params)
    date_params.update(date_to_params)
    props_to_filter = filter.property_groups
    if entity and isinstance(entity, Entity):
        props_to_filter = props_to_filter.combine_property_group(PropertyOperatorType.AND, entity.property_groups)
    prop_filters, prop_filter_params = parse_prop_grouped_clauses(
        team_id=team.pk, property_group=props_to_filter, prepend="all_cohort_", table_name="all_events"
    )
    query = f"""
            SELECT DISTINCT distinct_id, {ALL_USERS_COHORT_ID} as value
            FROM events all_events
            WHERE team_id = {team.pk}
            {parsed_date_from}
            {parsed_date_to}
            {prop_filters}
            """
    return query, {**date_params, **prop_filter_params}
def format_breakdown_cohort_join_query(team: Team, filter: Filter, **kwargs) -> Tuple[str, List, Dict]: