How to change 'metric/legend' name when using Azure App Insight Analytics?

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

Nvm. Able to use pivot.