Hello everyone.
Want to display the output only for the time which crosses 18 months (earliest time)
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