New to Grafana - Getting Data to Show Graphically

  • What Grafana version and what operating system are you using?
    v8.0.0

  • What are you trying to achieve?
    I am new to Grafana and I am really excited to be able to use this. I work with a car wash handling analytics. I am trying to show a graph with the car count as the y axis and the date as the x axis.

  • How are you trying to achieve it?
    I have a query that works well in SSMS, but it doesn’t work the same on Grafana.

  • What happened?
    When I get the query to work with no errors in Grafana, nothing is shown on the graph or in table view so I don’t know what to do to fix it. I know I need a time field for the graph view and I’ve tried the help sections conversions, but I cannot get it to show anything.

  • What did you expect to happen?
    I need the car count as the y axis and the date as the x axis.

  • Can you copy/paste the configuration(s) that you are having problems with?
    Here is an example query that I was able to get to show data in a table view, but it doesn’t show anything on the graph other than the axis’s.
    Select LocationId, WashDate as ‘time’ from WashInvoice where LocationId = 14

  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
    No, I don’t receive any errors - that I know of. No notifications or anything.

  • Did you follow any online instructions? If so, what is the URL?
    The only page that I found that gave me hints was:
    https://community.grafana.com/t/data-does-not-have-a-time-field-what-do-i-have-to-do-to-get-grafana-recognize-time-attribute/49229

Hi @WuchaDoin and welcome to the forum :wave:

If you click on the dropdown for the panel and select the inspect drawer and then look at query, what do you see? Can you copy and paste that full raw query request and response? (put in a code block using triple backticks ( ``` )?