Some aggregate functions can create multiple results. For example, when computing the MODE of a set of data, if there is more than one value which is the most frequently observed (a tie of two or more values) each is considered the MODE of the data. The following general rule applies to any aggregates which return more than one result:
- If a query has only one aggregate function with multiple results, all results are returned. There will be more than one result row for at least one timebucket, where the only value which differs in the result rows is the result of the function which had multiple results.
- If more than one aggregate function has more than one result, only one result per timebucket is returned, along with a warning that this occurred. There is no way of predicting which result will be processed first. This type of request can be seen in Example: Multiple Results Found for One or More Time Series Aggregate Functions.