Non limit but filtered pannel

  • What Grafana version and what operating system are you using?
    I’m using Grafana 10.4.2 in a Ubuntu VM

  • What are you trying to achieve?
    I have a ElasticSearch datasource. This datasource (Elasticsearch index) is massive in terms of data ammount. In fact, it is updated every 30s +/- with more info, so I need a high refresh rate.
    What I’m trying is to get a pannel to show 4 fields of all the index. As the index is massive, i filtered the info without empty rows and that stuff.

  • How are you trying to achieve it?
    I put the limit of the representation to 10.000 and filter the info by overrides and transformations.

  • What happened?
    Even representing 10.000 data rows, it only shows the last 2 hours of data, it takes a year to load and can’t find all the info I want.

  • What did you expect to happen?
    I expect to find a way to tell the pannel to show the info I want. I don’t know if there’s a way to get all the data but not show it, only showing the filtered, or how can I solve this problem. I want to get all the info but display only the filtered.