Using TSQL, I have output of two columns (CustomerName and TicketCount). I am trying to make a bar gaugue that displays the value in CustomerName field and the value in TicketCount field. Grafana shows the expected output in a table visualization but when I change visualization to a bar gauge, my categories show the column name of the metric (TicketCount). I can’t for the life of me get it to display the values from the CustomerName column.
I’m sure I’m missing something simple as this is a pretty basic use case for a bar chart in all charting software. I’ve searched the community and online and don’t find what I’m looking for.
Any help is appreciated.