Group By Multiple Fields
Many Composer 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 Composer connectors is shown in the following table.
Key:Y - Supported; N - Not Supported; N/A - not applicable