Additional Aggregations in ADX Query Builder

[andresmgot]

Discussed in #329

^{Originally posted by savastosic March 9, 2022}
It would be extremely helpful for my users to have a more powerful query builder for the ADX plugin, specifically around aggregations.
Currently when using the builder, users are limited to the following aggregations:

• Sum
• Avg
• Count
• Dcount
• Max
• Min
• Percentile

This feels rather limiting when comparing it to connectors for other data sources. For example, the InfluxDB connector gives the following aggregations:

Of course this is possible by editing the native ADX queries, but the end users are not willing to learn and use KQL.

[andresmgot]

The goal of this issue is to check if there are more function available that we can add to the query builder and verify that the output format is correct.

[MFourZero]

@andresmgot, @alyssabull : where can I find updates on this issue (or feature requests)? It is really relevant for us as well.