How to set the condition for output.

[rajhemant26]

Hello everyone.

Want to display the output only for the time which crosses 18 months (earliest time)

[harishalipaka]

hi @rajhemant26

try like this

| makeresults
 | eval Date="12/08", shiftA=102, shiftB=10, shiftC=200
 | append 
     [| makeresults
      | eval  Date="25/08", shiftA=240, shiftB=102, shiftC=52]
 | table Date shift*
 | eval Max=0
 | foreach shift*
     [eval Max=case(Max>=<<FIELD>>,Max,true(),<<FIELD>>)] |sort - Max |head 1