percentage of one field event over other

[pratik151]

I have two query

1: sourcetype=A error=499
2: sourcetype=A X=*

2nd query is almost equal to total transactions.

I would like to make timechart of % of error count on X events.

Basically I want to make timechart that will tell if error code increase is because of volume increase etc,

[to4kawa]

 index=foo sourcetype=A (error="*"  X="*") 
| eval error=case(error="499",1,true(),0)
| timechart count as total sum(error) as error
| eval perc=round(error / total * 100,2)

[woodcock]

Like this:

index="YouShouldAlwaysSpecifyAnIndex" AND sourcetype="A" AND (error="499" OR X="*")
| timechart count(eval(error="499")) AS error499count BY X

[richgalloway]

This should get you started.

index=foo sourcetype=A (error=499 OR X=*) 
| bin span=1d _time
| stats count(eval(isnotnull(X)) as Total, count(eval(error=499)) as Error by _time
| eval Pct = (Error * 100) / Total
| timechart span=1d max(Pct)