please help me with this query
fetch spans, samplingRatio: 1, scanLimitGBytes: 500
// if in "requests" mode
| filter request.is_root_span == true AND isNotNull(endpoint.name)
// based on the applied filters
| filter in(`dt.host_group.id`, { "fin-iac-rel-prod-atm-pr", "fin-iac-rel-prod-csp-pr", "csp", "fin-iac-rel-prod-cspi-pr" })
and (in(`k8s.workload.name`, { "wasp" })
OR in(`dt.kubernetes.workload.name`, { "wasp" }))
and in(`endpoint.name`, { "/wasp/api/transactions/authorisation", "/wasp/api/notifications", "authorise", "/wasp/api/transactions/completion" })
// calculate multiplicity based on sampling
| fieldsAdd sampling.probability = (power(2, 56) - coalesce(sampling.threshold, 0)) * power(2, -56), sampling.multiplicity = 1/sampling.probability, multiplicity = coalesce(sampling.multiplicity, 1) * coalesce(aggregation.count, 1) * dt.system.sampling_ratio
// construct fields
| fieldsAdd request.status_code = if(request.is_failed, "Failure", else: "Success")
// for multiplicity (due to sampling) sum() needs to be used instead of count()
| fieldsAdd failedIf = if(request.status_code == "Failure", `multiplicity`, else: 0), successIf = if(request.status_code == "Success", `multiplicity`, else: 0)
| makeTimeseries {
failure = sum(failedIf, default: 0),
success = sum(successIf, default: 0),
avg = avg(duration),
p50 = median(duration),
p90 = percentile(duration, 90)
}, bins: 120, by: { dt.system.sampling_ratio }
In above DQL, how can I have success and failure as bar charts overlayed on the line chart but the y axis has different values for bar chart ?
