You are viewing our older product's guide. Click here for the documentation of GoodData Cloud, our latest and most advanced product.
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.
ALL IN ALL OTHER DIMENSIONS can be abbreviated as “All Other.”
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