I’m using Grafana 11.5.2 and I am currently facing issues with plotting GPS data. I am using InfluxDB as datasource.
My database provides grafana with values, which I want to have separated based on there frequency band (L1, L2, L5).
I already tried to group these values based on their “freq” tag as you can see in the image below, but the name of the value will still be CN0, so when plotting the bar diagram the legend only shows CN0 three times.
I have found a solution without the “Group by Matrix” transformation by setting up three different queries, each selecting values with the specific tag (L1, L2, L5) and combining them using the “Merge Series/Tables” transformation.
However, I now have the problem that I only want to display the CN0 values with the same last timestamp. I know I could enter a query option with relative time, but I want a more flexible solution that is not dependent on the refresh rate of my database.
In this example, I only want to see the values with the timestamp (2025-03-06 13:36:54.000).
Hmmm…I think this is possible with a series of transformations (filter by common timestamp?). I’ll mull it over and post back if I can come up with something, or someone else here can chime in and save the day.
It works with the transformation ‘Partition by values’ but I’ve already seen some bugs when plotting the data. I guess it’s because it is still in the development phase.
First I sort by time (in reverse) to have the latest timestamp at the top. Then the ‘Partition by values’ transformation, which splits my data into blocks, with the current block being the one with the most recent timestamp. Finally, I sort by satellite name again to make the panel look nicer.
