Aggregate function APPROX_COUNT_DISTINCT( [ DISTINCT ] <expr1> [ , ... ] ) APPROX_COUNT_DISTINCT(*) Window function APPROX_COUNT_DISTINCT( [ DISTINCT ] <expr1> [ , ... ] ) OVER ( [ PARTITION BY <expr2> ] ) APPROX_COUNT_DISTINCT(*) OVER ( [ PARTITION BY <expr2> ] ) Argu...
For more information, see Using level-aware calculations in Amazon QuickSight. Example The following example gets the count of Sales partitioned over City and State. countOver ( Sales, [City, State] ) The following example gets the count of {County} partitioned over City and State. ...
The use of theCOUNTfunction in Bigquery is to return a single value from the number of rows in the input. TheDISTINCTclause withCOUNTis used only to eliminate any duplicate row in the table. Apart from theDISTINCTclause, one can also use theOVERclause, which is optional and states a window...