Timelion - Failure Rate problem

Elastic Stack Kibana
1

Dear All,

I would like to create Timelion line chart which should show the failure rate in %.
The 'info' field shoudl contain 2 value. FAILED or PASSED
I have this query:

(.es(index=my-index-*,timefield=@timestamp,q='name: "Ape Report Result -" AND result:"First run*" AND info:FAILED',metric=count).divide(**13**)).cusum().multiply(100)
This is good:

image
image1136×497 19.1 KB

It shows the good chart as I expected, but only when I hardcoded a value into the divide function.

How can I substitute the "13" with a count number based on another query.
Like this:

   .es(index=my-index-*,q='name: "Ape Report Result -" AND result:"First run*" AND info:*')

It should give the passed + failed records as well.
I tried to include it into the divide function but the result is bad:
(.es(index=gbucs-docstore-*,timefield=@timestamp,q='name: "Ape Report Result -" AND result:"First run*" AND info:FAILED',metric=count).divide(.es(index=my-index-*,q='name: "result: First run*" AND info:*'))).cusum().multiply(100)

image
image1536×607 10 KB

Can somebody help me?

Thanks!

2

I think I found the solution. :smiley: added .aggregate(sum)

3

Just one question.

Is there any way to create smoothed lines in Timelion?