Group By Multiple Fields
This applies to: Visual Data Discovery
Many connectors can group by more than one field in a query. Here is a sample SQL query:
select firstField, secondField, count(distinct otherField) from myCollection group by firstField, secondField
If multi-group querying is not supported, some visuals will be unavailable for a data source.
Support for this feature by connector is shown in the following table.
Key:Y - Supported; N - Not Supported; N/A - not applicable
Connector | Supported? | Notes |
---|---|---|
Y |
|
|
Y |
|
|
Y |
|
|
Y |
|
|
Y |
||
Y |
|
|
Y |
If you need to access a BigQuery partition, explicitly include an alias for the built in partition column in your select clause, such as |
|
Y |
|
|
Y |
|
|
N |
|
|
Y |
|
|
Y |
|
|
Y |
|
|
Y |
||
Y |
|
|
Y |
|
|
Y |
|
|
Y |
|
|
Y |
|
|
Y |
|
|
Y |
|
|
Y |
|
|
Y |
|
|
Y |
|
|
Y |
|
|
Y |
|
|
Y |
|
|
Y |
|
|
Y |
|
|
Y |
|
|
Y |
|
|
Y |
|
|
Y |
|
|
Y |
|
|
Y |
|
|
Y |
|
|
Y |
|
Comments
0 comments
Please sign in to leave a comment.