Config from query results (Elastic x CSV)


Grafana 9.x

I kinda of new on using Elasticsearch and complex querying on Grafana, need some help here…

I try to use query A to act as a threshold for query B
query A - CSV data source
query B - Elasticsearch data source

Query A consist of multiple fields below is a example of my CSV format and values
<------------------------ CSV --------------------------->
<------------------------ CSV --------------------------->

Using this data source to query and filter out data from query B (Elasticsearch). Looking for filename contain “CustFile” where my @timestamp is between 11:00 to 11:15, if inside of the time range then update query A data table’s field to “PASS” else “FAILED”/value mapping.

Can anyone give me example/guidance…

Thanks in advance