I ran a query which gave results in the below manner
I just want the last two columns, that is Today and Tomorrow and remaining columns values to be added to a new column saying Yesterday.
As in, I want my result in only 3 columns as Today, Tomorrow and Yesterday.
Any ideas how to do?
Thanks
Hi @ashokpuvvada
Try this
| makeresults
| eval friday=20, monday=20,saturday=10, sunday=20,today=10,tomorrow=30,yesterday=0
| foreach friday,monday,saturday,sunday
[ eval yesterday = yesterday+<<FIELD>>]| table yesterday,today,tomorrow