Group By Time
Many Composer connectors support grouping data by a real time field. This function is a prerequisite for all time-based visuals.
Most commonly, the data includes a date or time stamp field type that corresponds to Composer’s date field type. Here is a sample SQL query:
select timeField, max(otherField) from myCollection group by timeField
If grouping on time is not supported, some visuals will be unavailable for the 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
Please sign in to leave a comment.