## 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
table_name="e",
            person_id_joined_alias=person_id_joined_alias,
            person_properties_mode=person_properties_mode,
        )
    value_expression = _to_value_expression(
        filter.breakdown_type,
        filter.breakdown,
        filter.breakdown_group_type_index,
        filter.breakdown_normalize_url,
        direct_on_events=True if person_properties_mode == PersonPropertiesMode.DIRECT_ON_EVENTS else False,
        cast_as_float=filter.using_histogram,
    )
    if filter.using_histogram:
        bucketing_expression = _to_bucketing_expression(cast(int, filter.breakdown_histogram_bin_count))
        elements_query = HISTOGRAM_ELEMENTS_ARRAY_OF_KEY_SQL.format(
            bucketing_expression=bucketing_expression,
            value_expression=value_expression,
            parsed_date_from=parsed_date_from,
            parsed_date_to=parsed_date_to,
            prop_filters=prop_filters,
            aggregate_operation=aggregate_operation,
            person_join_clauses=person_join_clauses,
            groups_join_clauses=groups_join_clause,
            sessions_join_clauses=sessions_join_clause,
            null_person_filter=null_person_filter,
            **entity_format_params,
        )
    else:
        elements_query = TOP_ELEMENTS_ARRAY_OF_KEY_SQL.format(
            value_expression=value_expression,