SQL server issues

Hi, I have been trolling the internet to find answers, but very frustruated with Grafana so far. I am persevering. I downloaded the installer and installed Grafana onto a PC.

The SQL query I am using is:

getdate() time,
count(*) value,
Product_Code metric
group by Product_Code

But when I display it, it comes out as below:

Why is my data not shown in the table view?

  1. I want to display a bar chart grouped by product, but when I switch to a bar guage, I get “No data” displayed. I am expecting to get a simple bar chart like in Excel.

Please can you help me with this!!!


Install plugin Multistat:

Wow…this looks great…I will have a crack at it.

Thanks for posting!