search

grafana / azure-data-explorer-datasource

Grafana datasource plugin for Microsoft Azure Data Explorer (formerly Azure Kusto)
Apache License 2.0
47 stars 35 forks source link

Additional Aggregations in ADX Query Builder #438

Open andresmgot opened 1 year ago

andresmgot commented 1 year ago

Discussed in https://github.com/grafana/azure-data-explorer-datasource/discussions/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: ![image](https://user-images.githubusercontent.com/90868835/157550667-5fc700dd-78c1-4662-9275-bde4f4808bc7.png) ![image](https://user-images.githubusercontent.com/90868835/157550680-83ce3229-7bb2-4db2-8ef1-675e976b644c.png) ![image](https://user-images.githubusercontent.com/90868835/157550688-f3cc4471-ae77-4b24-bda8-2724fc717b78.png) Of course this is possible by editing the native ADX queries, but the end users are not willing to learn and use KQL.
andresmgot commented 1 year ago

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 commented 3 months ago

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