Is there a way to see metric aggregations from GA4 Query Explorer in Redash?

[M-arghandiwal]

I am creating a request in GA4 Query Explorer to get the total active users for page URLs containing a specific keyword (meaning I have to add a dimension filter).
To get the total active users, you have to use metric aggregations in the Explorer:

Request query looks something like this:
{ "dimensions" :[{"name":"fullPageUrl"}], "metrics" :[{"name":"activeUsers"}], "dateRanges" :[{"startDate":"2024-01-01","endDate":"today"}], "dimensionFilter": { "filter": { "fieldName" :"fullPageUrl", "stringFilter": { "matchType" :"CONTAINS", "value" :"something" } } }, "limit" :"250000", "metricAggregations" :["TOTAL"] }

The response in GA4 Query Explorer gives me two tables:

when I use the request JSON in Redash, it gives me only the first table. What do I need to do to get that 39596 number (the Metric Aggregations part) instead?

Just to be clear, I cannot sum the active users for all page URLs coz that gives me a different number due to the possibility of same user visiting multiple pages.