Hello,
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 --------------------------->
Filename,ExpStartTime,ExpEndTime
FalsePositive,10:00,10:30
CustFile,11:00,11:15
Exchg_Rate,22:00,22:15
<------------------------ 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