How can I add the results of some particular columns to a new column?

[ashokpuvvada]

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

[vnravikumar]

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