# Category Chart Reporting

**URL:** <https://forum.inductiveautomation.com/t/category-chart-reporting/12087>\
**Category:** Ignition\
**Created:** [August 30, 2016, 9:29pm UTC](https://forum.inductiveautomation.com/t/category-chart-reporting/12087 "2016-08-30T21:29:35Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![bfearnow](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bfearnow/32/3337_2.png) [@bfearnow](https://forum.inductiveautomation.com/u/bfearnow)\
**Post date:** [August 30, 2016, 9:29pm UTC](https://forum.inductiveautomation.com/t/category-chart-reporting/12087/1 "2016-08-30T21:29:35Z")

</div>

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.

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [September 1, 2016, 11:36pm UTC](https://forum.inductiveautomation.com/t/category-chart-reporting/12087/2 "2016-09-01T23:36:57Z")

</div>

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?