Difference of values ​​using single value with percentage

[leandromatperei]

I would like to put together a graph with the difference of values ​​as a percentage, so I can use the single value and if it is above 70% it would turn red.

index="teste" "ProcessInboundEmail" | timechart span=10m dc(id_email) as ProcessInboundEmail
| appendcols  [search index="teste""submitInboundEmail" ended | timechart span=10m dc(id_email) as submitInboundEmail]
| eval diff =  ProcessInboundEmail - submitInboundEmail | eval diff=if(ProcessInboundEmail< submitInboundEmail, diff * -1, diff)

can you help me?

[to4kawa · Accepted solution]

index="teste" "ProcessInboundEmail" | timechart span=10m dc(id_email) as ProcessInboundEmail
| appendcols [search index="teste""submitInboundEmail" ended | timechart span=10m dc(id_email) as submitInboundEmail]
| eval perc = round(abs(ProcessInboundEmail - submitInboundEmail)/(ProcessInboundEmail + submitInboundEmail)*100,2) | table _time perc

and modify FORMAT