Grouping is not working (as expected?) in a Time Series Panel

[nik15]

Using Grafana v.9.3.6 in Windows, hitting a MSSQL '19 database.

I am trying to make a time series plot with one or more additional properties as dimensions. I have read quite a few pages (grafana, grafana community , etc…) suggesting this should be fairly straight forward, but…

It seems like I can not get Grafana to understand that I have these additional dimensions, or groupings.

Here are a few different variations on the themes that I saw in all the postings. Hopefully this will show both the SQL query and the resultant graph.

An suggestions on where I am going wrong?

[jangaraj]

Try to format it as timeseries, not as a table:

I would use also $__timeGroup macro - Microsoft SQL Server query editor | Grafana documentation

[nik15]

Thank you for that suggestion. I have changed the format from Table to Time series where you suggest on all three variations and it does not change the graphing outcome.

I am looking into the $__timeGroup functionality.

[nik15]

thank you. I was able to get it to work with the multi-frame time series transformation. Here are a few images to show code and result for the record.

[jonathonrobinson]

Multi-frame Time Series does not allow for Alerts to be created. Is there another avenue that allows SQL queries to display multiple time series on the same graph and allow for alerting as well?