BY attribute ALL IN ALL OTHER DIMENSIONS

The first part of this keyword serves a similar role as the BY statement, defining an aggregation floor at the granularity level of the specified attribute. But the keyword also overrides all attributes in all other dimensions—keeping them from having any affect on the metric.

Syntax

SELECT … BY … ALL IN ALL OTHER DIMENSIONS
SELECT metric BY attribute ALL IN ALL OTHER DIMENSIONS

Examples

SELECT SUM(Resolution_time) BY Quarter ALL IN ALL OTHER DIMENSIONS