| inputlookup kv_adani | where (tag="CHP.Device1.C1 BELT VW" ) | eval _time=tagtime |dedup _time| stats max(_time) as maxtime, min(_time) as mintime,avg(value) as avgtph,count(value) as count by tag |eval td=(maxtime-mintime)/3600,tv=td*avgtph|stats sum(tv) as total_valueC1| eval total_valueC1= round(total_valueC1,0)
| eval total_valueC2= [search | inputlookup kv_adani | eval Tag=tag,_time=tagtime, Value=value |(Tag="CHP.Device1.C2 BELT VW" ) | dedup _time| stats max(_time) as maxtime, min(_time) as mintime,avg(Value) as avgtph,count(Value) as count by Tag |eval td=(maxtime-mintime)/3600,tv=td*avgtph|stats sum(tv) as total_value | eval total_valueC2= round(total_valueC2,0)| eval search = total_value] | eval total_value=total_valueC1+total_valueC2
... View more