You are viewing our older product's guide. Click here for the documentation of GoodData Cloud, our latest and most advanced product.
BY ALL IN ALL OTHER DIMENSIONS EXCEPT FOR attribute
This keyword clause overrides all attributes except for those attributes within the dimension of the attribute that is specified.
ALL IN ALL OTHER DIMENSIONS can be abbreviated as “All Other.”
Syntax
SELECT … BY ALL IN ALL OTHER DIMENSIONS EXCEPT FOR…
SELECT metric BY ALL IN ALL OTHER DIMENSIONS EXCEPT FOR attribute
Examples
SELECT Payment BY ALL IN ALL OTHER DIMENSIONS EXCEPT FOR Date(Opportunity Closed)
In this example, Payment could be broken down by any date in the Date(Opportunity Closed) date dimension, such as Month/Year(Opportunity Closed), Quarter/Year(Opportunity Closed), or Year(Opportunity Closed).