Graph panel showing date axis X, and Number axis Y

Grafana Time Series Panel
1

Hi, I’m trying to configure a panel showing two data:

  • Date
  • Qty (number)
    Following i attach an image showing the query and the result set: 2 columns (date and qty)
    This 2 values i’d like to show on a panel like graph, so i can see the qty for each date.
    I can make it work, it just shows empty.
    I also attach an image from grafana configuration panel.
    Thanks!

Screen Shot 2022-01-16 at 21.56.42
Screen Shot 2022-01-16 at 21.56.421592×1084 121 KB

Screen Shot 2022-01-16 at 21.57.25
Screen Shot 2022-01-16 at 21.57.251920×987 99.3 KB

2

Welcome to the Grafana forum.

It appears you are using SQL Server as your datasource? Below your query in Grafana, is there a dropdown box where you set the format as Time Series? If yes, then the query must have a column named time (not date). More info here.