Canvas Gauge with Timelion

Elastic Stack Kibana
1

Hi all,

Thanks in advance for you support.

I'm getting an interesting result in my Guage in Canvas.

image

The Guage is supposed to be showing the Referred Percentage of the values to the left, clearly this should be 47%.

Here's the Timelion query I'm using to drive the guage;

.es(index=o-p*, q='o.type:OutcomesUpdatedEventHandler')
.subtract(.es(index=o-p, q='o.type:OutcomesUpdatedEventHandler AND
o.verification.journey_outcome_bank:"Accepted" AND
o.verification.journey_outcome_fraud:"Accepted" AND
o.verification.journey_outcome_income:"Accepted"'))
.divide(.es(index=o-p, q='o.type:*OutcomesUpdatedEventHandler'))
.fit(none)

Can anyone help?!?!
Many Thanks.

2

Does this clause

match exactly the clause for "Accepted Journies"?

4

Thanks for your help Thomas...

Here are the three queries being used for the Metric elements on the Canvas.

Journies
.es(index=o-p*, q='o.type:*OutcomesUpdatedEventHandler')

Accepted Journies
.es(index=o-p*, q='o.type:*OutcomesUpdatedEventHandler AND
o.verification.journey_outcome_bank:("Accepted") AND
o.verification.journey_outcome_fraud:("Accepted") AND
o.verification.journey_outcome_income:("Accepted")')

Referred Journies
.es(index=o-p*, q='o.type: OutcomesUpdatedEventHandler')
.subtract(.es(index=o-p , q='o.type:*OutcomesUpdatedEventHandler AND
o.verification.journey_outcome_bank:("Accepted") AND
o.verification.journey_outcome_fraud:("Accepted") AND
o.verification.journey_outcome_income:("Accepted")'))