I’m querying App Insights using kusto query. The query is to calculate the successrate of a function app. I’m able to write it correctly using kusto query (Azure query language) and in grafana, it returns correctly in table. But when changing the visualization to say stat or gauge, its showing the column name instead.
In regular grafana query, i can simply do like
blah as metric
| where $__timeFilter(timestamp)
| summarize Total = count(), Success = countif(success == true), Failures = countif(success == false) by name
| project name, SuccessPercentage = Success*100.0/Total
| project-rename metric = name