Service Project: Can I show ticket entry & custom fields (eg complaint type) over time?

[virginia.fishburn]

We have a board to enter in data requests and complaints.

In my dashboard, I want to show ticket entry & ticket type over time, such as how many tickets have been submitted per month for the past 12 months (so we can see if we are trending better or worse), how many tickets of a certain type are submitted per month for the past 12 months (eg 12 missing data tickets 3 months ago and only 2 last month, 15 incorrect data tickets 6 months ago and 21 this month). We have used PowerBI before and had a hard time with it updating regularly enough so would love to have this functionality in our jira dashboard!

Thanks in advance!

[Marlene Kegel - codefortynine]

Welcome to the community, @virginia.fishburn.

Have you tried if the "Created vs. Resolved" gadget works for you? 

[Dave Mathijs]

Hi @virginia.fishburn welcome to the Atlassian Community!

Have you already tried building a custom report?

You need to be a project administrator to create or edit custom reports.

To create a new custom report:

1. From your service project’s sidebar on the left, select Reports.> New report.

2. Enter a name for your report.

3. Select Add series. What is a report series?

4. Select the required series from the Series drop-down menu.

5. Add a label name for the series that reflects what you’re measuring.

6. Select a colour to be displayed on the graph for the series data.

7. If desired, filter the series by issue type, status, priority, or component. Select + More to add more filters.

   • To filter using Jira Query Language (JQL), select Switch to JQL and enter the required information. Learn more about JQL.

   • Select Basic to return to basic filters.

8. Select Add.

9. If desired, select Add series and repeat steps 4–8 to add up to 20 series.

10. Select Create.