I am doing a calculation to add up all the time spent in each layer. But there are cases where few fields not existing/relevant. In that case how do i make it to consider only the fields present during runtime.
eval processing_time = Layera + layerb + layerc + layerd
Say a particular event doesnt have layerc - the processiing time isnt getting calculated. So how do i make it to ignore the fields which arent present ?
Hi @sangs8788
Try
your query...| fillnull value=0 Layera,layerb,layerc,layerd | eval processing_time = Layera + layerb + layerc + layerd
Hi @sangs8788
Try
your query...| fillnull value=0 Layera,layerb,layerc,layerd | eval processing_time = Layera + layerb + layerc + layerd
@sangs8788 ,
Try
|eval processing_time=if(isnull(Layera),0,Layera)+if(isnull(layerb),0,layerb)+if(isnull(layerc),0,layerc)+if(isnull(layerd),0,layerd)
OR
|eval processing_time=0|foreach Layer* [eval processing_time=processing_time+<<FIELD>>]