Hi,
I’ve connected an Azure SQL server to Grafana and successfully implemented a table that shows the following columns:
VmName, MonthlyConsumedByHours, ResourceGroup.
I want to implement graphs that the X-axis is the VmName and the Y-axis is the MonthlyConsumedByHours.
I’ve tried to do this:
SELECT
VmName,
MonthlyConsumed
FROM
[dbo].[VmConsumptionTable]
WHERE
ResourceGroup =‘HADERA-AMAL-MADAIIM’
ORDER BY
ResourceGroup ASC
But it seems that nothing appearing on the graph window, although I do see data using “Query Inspector”.
What am I doing wrong?
Thanks,
Jordan.