Time series Table transformation help

  • What Grafana version and what operating system are you using?

Open source Grafana v9.5.1 on Ubuntu

  • What are you trying to achieve?

We have multiple time-series coming as different “live measurements” data sources (through websockets):

time=x Component1Metric1=y
time=x Component1Metric2=y
time=x Component2Metric1=y
time=x Component2Metric2=y

We’d want to show a table with the latest values broken down by component and metric, like:

Screenshot 2023-05-12 at 11.40.35

  • How are you trying to achieve it?

Tried many regex value mapping override and multiple transformations (series to row, grouping to matrix) but couldn’t make it work.

  • What happened?

I feel that this could be achieved with the provided config tools but couldn’t get the table to show the data the way I wanted.

Thanks a lot!

Welcome

Could you please show a more realistic sample data with proper data types for metrics values and times?

And are you using a websocket plugin?

Thanks for your reply,

Attaching a picture with the current config. Not using any websocket plug-in, but the Grafana -- Live Measurements source time that ships by default (as part of Grafana Live)

There are four more configured metrics for the table panel (not visible due to scroll): PCCA_I2C_CommsMetricsUsBusError, PCCB_I2C_CommsMetricsUsBusError, PCCA_I2C_CommsMetricsUsOk, PCCB_I2C_CommsMetricsUsOk

Ideally, would want the table to look like this (showing latest values, example assumes all come as 0.0):

1 Like

Bumping this up - any insights? appreciate the help