How can I Overlay bar chart on a line chart?

virdavindersing — Mon, 16 Jun 2025 06:36:33 GMT

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 ?

Re: How can I Overlay bar chart on a line chart?

marco_irmer — Fri, 13 Jun 2025 21:39:42 GMT

I haven't run your query, but I will assume that it outputs multiple timeseries that you wish to visualize in a single panel using different chart types. If that is true, then you may not need to change your query at all.

You can combine different chart types by using the custom geometry option within the visualization settings.

I hope that helps.

topic How can I Overlay bar chart on a line chart? in DQL

How can I Overlay bar chart on a line chart?

Re: How can I Overlay bar chart on a line chart?