Dashboards for different querters

[Nidhi singh]

Hello All,

Can anyone know how do I create dashboards based upon different quarters in Jira cloud for below requirements

Management Quarterly Dashboard Metrics per project:

• Who is working on each Quarter goals (Epics = goal)?

• Who is carrying over the stories each sprint in that quarter

• Original Estimate vs Time spent by assignee by quarter

• Percentage of time by Productivity category in that quarter

• Time spent by the assignee on each quarter Epic -Done

• List of all orange and white goals • Issues created by other projects

[Jim Knepley - ReleaseTEAM · Accepted solution]

The way I've seen that done is to use the startOfYear function to identify the date range of a quarter. For example, for issues resolved in the first quarter:

resolved >= StartOfYear() AND resolved <= StartOfYear(3M)

It's not great since you have to update the dashboard queries every quarter.

You can also get add-ons that extend JQL with functions like this.

[Aron Gombas _Midori_]

I think you should:

1. create smart filters and JQL queries and use those as inputs to your gadgets
2. plus try if the Quick Filters app can be used to dynamically change the inputs

With this technique, maybe it is sufficient to create a single dashboard, and use a dynamic selector to choose the quarter to report on.

[ramyaallena]

Hi @Nidhi singh ,

Have you achieved this in your dashboard? If yes, Could you please share the details of how you made it?

Thanks,

Vijaya Ramya Allena

[Seon Shakespeare]

Hi @Nidhi singh

Creating dashboards for specific quarters in Jira can be a bit tricky, as it doesn't have built-in functionality for that. You'd have to manually update date range filters quite often.

For more advanced reporting, you might want to check out the Atlassian Marketplace for apps that enhance Jira's reporting capabilities: https://marketplace.atlassian.com/

At my company, we use an app called easyBI for this kind of thing. It integrates really well with Jira and makes it much easier to create dashboards and reports that automatically track data by quarter. It's a paid add-on, but it might be worth looking into if you need that level of reporting power.

I hope that helps!