0

I am trying to get a row count in a Grafana dashboard, and was working fine when I first set it up. But now I am seeing inconsistent results in Grafana and ADX: Specifically, Grafana variable is getting a value of None. No amount of typecasting seems to solve the issue...

Azure Managed Grafana v11... Here are three screenshots A query that returns the count in ADX .

KQL query in Data Eplorer The same query that does not in Grafana.

KQL query in Grafana Some typecasting not working in Grafana

KQL Query cast toscalar

I expected Grafana variable to be equal to the count being returned from KQL.

Improve this question
1
  • Could you post direct images instead of images link Commented Mar 19 at 5:56

1 Answer 1

Reset to default
0

Grafana - Dashboard Variable - KQL - count not working

The query which you tried is by using toscalar(), means it is mostly used when its output is being used inside another expression. So, instead you can try with the below query, it uses summarize and count() function which shows the count successfully as it shows in ADX. Also, check whether the ADX is connected successfully with Azure Grafana and select the particular cluster, database and Format as Table as shown in the below image. enter image description here

FlightData
| summarize row_count = count()
| project row_count

Output: enter image description here

Below is the same query which it also runs successfully in ADX as shown in the below image. enter image description here

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.