Alert for OpenSearch Datasource gets wrong value

I’m using Grafana 8.3.3 with AWS OpenSearch service 1.1.

Visualization worked.

However, it looks like alerting is buggy. It shown no data:

Sometimes, it shown 0 in Time series and 2228-05-25 04:43:59 and 17 hours aggregation in Table.

If I used Elasticsearch Datasource for the same OpenSearch URL, it worked:

If I saved the alert for OpenSearch Datasource, it said no data, but it shown the collect graph in Explore

Does anyone successfully create an alert for OpenSearch Datasouce?

Add more graph because this forum blocked me to add 3 or more images.

Visualization worked.

If I saved the alert for OpenSearch Datasource, it said no data, but it shown the collect graph in Explore

Observed the same behavior with Grafana v8.5.4. Was able to query on OpenSearch data source using Explore and it applies the 15 minute time interval set in absolute time range.

Then attempted to create unified alert with same query. Tested query with message appearing in plot (in time series mode) indicating data outside time range.

Viewing the plot again (in table mode) shows that it attempted to query starting from the point in time when data was first stored on the data source, disregarding time range set in query.