"Summarize count() by <field>,bin_auto(_time)" statements do not visualize as different series

[jvv-trackunit]

While using the plugin version 0.3.0, I created a dashboard panel that showed the number of log messages logged at each severity level over time:

I used the following query to power this:

['global']
| where ['resource.env'] == "dev"
| summarize count() by ['severity'],bin_auto(_time)

I used the following transformation

to convert the result series from the format

to the format shown in the first screenshot.

After upgrading the Axiom data plugin to version 0.5.1, my dashboard shows a single count instead of individual counts per severity:

This seems like a regression. I expected that it would still show 1 line per severity. I have tried using Grafana transformations to get individual series again, but without success.

The dashboard used to demonstrate the bug is here:
series-bug-dashboard.json

Versions used:
Grafana v11.2.0 (2a88694fd3)
Axiom plugin: 0.5.1

[thesollyz]

hi @van-vliet, In version 5.0.0 we switched the returned data format, perhaps I missed something. I will take a look and get back to you.

[thesollyz]

@van-vliet Can you try to add a transformation that changes format from Long to Wide? That solved the issue for me for one of the charts. You can do that temporarily until I figure out the full solution.

[jvv-trackunit]

@SollyzDev I am not sure what you are asking me to do.

I tried adding a type conversion transformation in Grafana. I see the following, but no options mention a long or wide format:

I also tried modifying my Axiom query to:

['global']
| where ['resource.env'] == "dev"
| summarize tolong(count()) by ['severity'],bin_auto(_time)

but that did not solve my issue either.

Can you provide an example of the change you performed that worked?

[thesollyz]

@van-vliet The transformation is called "Prepare time series". Add it, then choose "Multi-frame time series" like the screenshot below:

I will include a fix in the next version that will do this transformation automatically.

[jvv-trackunit]

@dasfmi I see that this was potentially fixed here: #77
This is part of the release 0.5.2, which is available on Github.

Our installation pulls the plugin from here:
https://grafana.com/grafana/plugins/axiomhq-axiom-datasource/

When will version 0.5.2 be available there?

[thesollyz]

hi @jvv-trackunit , I have submitted the new version of the plugin to the Grafana marketplace but its still under review, once they approve it will be released. Usually it doesn't take all that time, will ping them.

[jvv-trackunit]

Hi @dasfmi
Latest version on the Grafana marketplace is still 0.5.1. Is something blocking it?

[thesollyz]

@jvv-trackunit yes, the Grafana team required an update to the SDK to overcome a security risk the grafana-go-sdk version. I made the upgrade and the necessary changes and submitted a new v0.6.0 release. Waiting again for their approval.

[thesollyz]

@jvv-trackunit version 0.6.0 is out 👍

[jvv-trackunit]

Hi @dasfmi

I tested my dashboard with the 0.6.0 plugin and the issue is still present. Can you reopen this?

[thesollyz]

@jvv-trackunit thats weird, you should at least see a different view now. Can you click inspect query on Grafana and show the query result?

[jvv-trackunit]

Hi @dasfmi

Here is the query and response:
grafana-query.json

Grafana version 11.3.0
Axiom plugin version 0.6.0

[thesollyz]

hi @jvv-trackunit I just did a test and you are right, it doesn't automatically render multi-frame series results. A Fix is not straight forward since we now use different format for the query result. Although the solution I mentioned before works. On your chart add a new transformation, under "Prepare Timeseries" like the image below:

You should then be able to select multi-frame time series as a format: