Show Table values horizontal

Hello,

I have the following visualization:

Here is the code for one of this lines:

from(bucket: "mybucket")
  |> range(start: 2024-11-14T23:30:00Z, stop: now())
  |> filter(fn: (r) => r["topic"] == "***/devices/cubecell-board-3/up")
  |> filter(fn: (r) => r["_field"] == "uplink_message_decoded_payload_Batterie")
  |> filter(fn: (r) => r["_measurement"] == "thing_network")
  |> aggregateWindow(every: 1d, fn: mean, createEmpty: false)
  |> yield(name: "mean")

I would like to see in an additional visualization just the values in a table like this:

image

With the second visualization I will check faster different values over the days, also if the difference is minimal.

If I just change the visualization type to table it’s showing the values vertical:

Any idea how to solve that?

add transpose transformations.

2 Likes

But first you need to modify your date-time to DD-MM

Disco lights

1 Like