Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Sigrid Schoepel
Contributor
November 5, 2021

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:

image.png

1 answer

1 accepted

1 vote
Answer accepted
Morgan Folsom
Atlassian Partner
November 5, 2021

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

Screen Shot 2021-11-05 at 7.46.10 AM.png

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

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
CLOUD
PRODUCT PLAN
STANDARD
PERMISSIONS LEVEL
Product Admin
TAGS
AUG Leaders

Atlassian Community Events