Vizualisation with OpenSearch datasource

[oxlrath]

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

  Dockerized grafana/grafana:11.1.4

• What are you trying to achieve?

  I want to use grafana-opensearch-datasource and display data on a dashboard. (opensearch 2.16.0)

• How are you trying to achieve it?

  I tested to query the data in explore - without any issues.

  

  The raw data is also shown as expected

  

• What happened?

  But when I try to add it to a dashboard - it does not show any data.

  

  

  As I had issues with time-formats before, when using Loki as datasource - I checked the data type of my time field, but was also not able to convert it:

  

• What did you expect to happen?

  Seeing the exact same graph, but as time-series inside a dashboard.

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

  Default config with the data source.

  The container stack: GitHub - O-X-L/dmarc-analyzer: Dockerized DMARC Analyzer

• Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were.

• Did you follow any online instructions? If so, what is the URL?

  Searched for solutions for a few hours… But without finding any solution.

I guess it might a easy fix. But I’m out of ideas for now

[jangaraj]

I don’t see any group by <some date field> in the dashboard query - that may be a problem. Query may return only scalar, not timeseries in this setup.

[nicerath]

Was just cut-off because of the smaller screenshot - sorry. Have checkt it but it’s the same as in explore

[jangaraj]

Use query inspector and compare both queries for difference. I guess interval:auto (also interval in query options) doesn’t play very well with Opensearch in this case. Use hardcoded value, e. g. 1d to prove it

[oxlrath]

Greetings.

Thank you for your help - did not know about the query-inspector. I appreciate it!

My untrained eye did not see any meaningful difference.
Here is the diff of the Panel data directly after adding it to the dashboard for reference: grafana-opnsearch-explore-vs-dashboard - Diffchecker

Setting the bucketAggs - settings.interval to something other than auto makes no difference.

[oxlrath]

Here the full data dump: Explore, Dashboard

[jangaraj]

I would say that maxDataPoints is low for 7d with 10min aggregation:
7days x 24 hours x 60 minutes / 10min = that’s 1008 points returned from the query, but maxDataPoints: 901 limits that results. Enable Grafana debug logs and check what’s there for that empty query.