Category Chart Reporting

Hopefully I am looking over something again.

I’d like to have a chart with a barchart of (reason vs. top total downtime) and a line of (reason vs. count of instances). I have both coming from a query.

Looks like the XY chart would fit the bill as you can have both chart types on one graph and even separate y axes, however I believe this only takes numeric values for the x-axis and mine would be a string.

Is this possible some other way? Thanks.

It’s messy, but you could collapse your reason codes into integers in your query, then re-format them back to strings in the chart formatting.

Alternately, maybe the Bar Chart and the Pareto option?