Custom Charts: How do I report by week by issue type of issues in specific statuses that week?

[Sigrid Schoepel]

Hello, I have a Custom Charts gadget with custom JQL to get a week-by-week (8 weeks) view of issues that were in specific statuses that week. I would like to break that out into three lines by issue type but I don't know how to do it.

This is a sample of the week 8 custom JQL:

status was in ("Investigated", "Open", "Waiting for Support", "Waiting for Customer", "Development") DURING (startOfWeek(-8), endOfWeek(-8))

I cannot divide this into three, I just get more spots along the X axis.

This is what it looks like:

[Morgan Folsom · Accepted solution]

Hello Sigrid!

To change this chart in the way that you've described, all you'll need to do is:

1. Change the Chart Type to a 2D Line Chart, and
2. Select Issue Type for your Group By

That way, the x-axis will still be your custom JQL but you can define the individual lines by issue type.

Kind regards,

Morgan

Custom Charts Support Team