How do I compare today’s and yesterday’s data to highlight

[chriswn]

I have the following table. If the number of scg fail on the day is twice that of the previous day, I want to highlight it. How should I do.

Hope you can help. Thanks!

date	scg_fail_number
1/01	12
1/02	24
1/03	30
1/04	60

[manjunathmeti]

hi @chriswn ,
Use delta command. Try this:

| makeresults 
| eval _raw="date	scg_fail_number
1/01	12
1/02	24
1/03	30
1/04	60
1/05	20" 
| multikv forceheader=1 
| delta scg_fail_number as diff 
| eval is_twice=if(2*diff>=scg_fail_number, "YES", "NO")
| table date, scg_fail_number, is_twice

If this reply helps you, an upvote/like would be appreciated.

[chriswn]

hi 

Thanks for your reply.

But what I want is what I show, I don’t want to add new fields.