Sample query for Pi chart from Azure data explorer data source

Can I get sample query for reference , I need to make Pi chart to show health of service over the time ( like for last one hour, one day, one week etc.) where the Up & Down % will be shown on the Pi chart.
The data in ADX will have columns: health status & time stamp

  • What Grafana version and what operating system are you using?
    Latest version
  • What are you trying to achieve?
    Pi chart for service health status
  • How are you trying to achieve it?
    Using Panel configuration and data query
  • What happened?
    Not able to find the exact configuration
  • What did you expect to happen?
    Pi chart showing the % of up and down status of a service over the time
  • Can you copy/paste the configuration(s) that you are having problems with?
  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
    Not getting expected output
  • Did you follow any online instructions? If so, what is the URL?

Hi @anishpk123

I do not use the Azure Data source so cannot tell how to write queries.

However, I found some good reference that explains the steps on how to use Azure Data Explorer and create some Dashboard panels.

Here is the link to the original documentation at our website. Also, found both (documentation and a video tutorial) from the web.

I hope this helps and hopefully other community members can provide more information to your question.

1 Like