I'm unable to load the data. index=abcd time_hour>4 (time_hour<11 OR (time_hour<12 time_minutes<31)) | eval time_hour=strftime(_time,"%H") | eval time_minutes=strftime(_time,"%M") |lookup locations.csv source OUTPUT Region SOD | search Region = APAC | eval Status=case(Statistic=0,"Green" , Statistic=2,"Red", Statistic=1,"Blue", 1==1, " " ) | appendpipe [ stats count | eval Status="Black" | where count=0 | fields - count] | stats latest(Status) This is the query I'm using please check
... View more