Difference between Explore and Table Panel on Dashboard

  • What Grafana version and what operating system are you using?
    v9.2.5 on Ubuntu 20.04

  • What are you trying to achieve?
    Display data in a table panel on a dashboard

  • How are you trying to achieve it?
    With a flux query (InfluxDB 2.5)

  • What happened?
    In Explore the query works fine and displays everything in one table.
    In the table panel the table is split up in many small tables but I am using the same query.
    I did try to merge the tables with transformations, but it didn’t work.

  • What did you expect to happen?
    Show data from Influx database in one table

  • Can you copy/paste the configuration(s) that you are having problems with?
    Flux Query:

from(bucket: "my-bucket") |> range(start: v.timeRangeStart, stop: v.timeRangeStop)
  |> filter(fn: (r) => r["_measurement"] == "Eventer" or r["_measurement"] == "Farberkennung" or r["_measurement"] == "Personenfilter" or r["_measurement"] == "importer")
  |> filter(fn: (r) => r["_field"] == "nachricht" or r["_field"] == "motornummer" or r["_field"] == "level")
  |> filter(fn: (r) => r["level"] == "Fehler")
  • Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.
    No errors

  • Did you follow any online instructions? If so, what is the URL?
    I found nothing related to this topic.

My main question is, if there is a difference between table panel and explore and how can I configure the table panel to look like the view from explore.

Thank you in advance.