Is there a way on the dashboard or an app that will show me these things?

[Hiromichi Kikuchi]

It does not need to show all of this but if it is possible I would like to see all of these things

* Filter by start date/end date, open/closed/completed statuses, assignees, sub-groups of assignees, DEPARTMENT, etc.

* Sorting by custom fields (or specified fields) and MAINTAINING JIRA/STORY/SUB-TASK in ALL reporting is very important.

*GRAPHS - late/on time for aggregate department and/or individual, perhaps also looking at priority (critical, medium, low, etc. -- system field).  Any other graphs that make sense for a manager to evaluate workload and performance. 

* Consider reporting the need to use the custom DATE COMPLETED field, compared to the DUE DATE (system field?) to determine late/on-time tasks.  Can JIRA or JIRA REPORTING APP handle this.

[Trudy Claspill · Accepted solution]

Noting that these same items were included in a post from April 25 that has not, as of today, garnered any suggestions:

https://community.atlassian.com/t5/Jira-Work-Management-Questions/I-need-help-to-find-an-app-that-will-show-me-these-things-below/qaq-p/2682176

[Trudy Claspill]

Hello @Hiromichi Kikuchi 

You have not provided any definition concerning the presentation of the output of these reports. Are you looking for lists of issues, or counts/tabulations?

* Filter by start date/end date, open/closed/completed statuses, assignees, sub-groups of assignees, DEPARTMENT, etc.

From the View All Issues screen you can create filters where you set the values for each of the criteria. Depending on how you want to combine the criteria you would need to create multiple filters.

If you want a presentation where you can have the same form of output and simply change the criteria on demand, that would require a third party app. Something like Rich Filters for Jira Dashboards might meet your needs in that case. (Note that I have never used that app myself.)

* Sorting by custom fields (or specified fields) and MAINTAINING JIRA/STORY/SUB-TASK in ALL reporting is very important.

Maintaining the hierarchical display when sorting based on other fields is not possible with the native filtering and output capabilities. That would also require a search for a third party app.

Given the complexity of the above items and the others you have mentioned you may want to consider investigating the third party apps that provide robust reporting capabilities. I don't have much experience with those myself. There are a variety of custom apps that can be used to create charts and graphs. Here is a search from the Atlassian Marketplace to help you get started investigating them.

https://marketplace.atlassian.com/search?hosting=cloud&product=jira&query=reports%20and%20graphs

Another app that didn't come up in that search that also provides more robust reporting capabilities is eazyBI.

[Valeriia_Havrylenko_SaaSJet]

Hi @Hiromichi Kikuchi  👋

Try out Time in Status for a complete solution for planning your projects, tracking the time in status and also time spent by your resources with multiple charts, dashboard gadgets options. With our add-on, you have the power to tailor your team's work schedule, ensuring that the calculation is based solely on productive working hours filter by

1. start date/end date (data trim period),

2. open/closed/completed statuses,

3. assignees, sub-groups of assignees, DEPARTMENT, etc.

Sorting by custom fields (or specified fields) and MAINTAINING JIRA/STORY/SUB-TASK in ALL reporting 

All report are available by Pie chart, GRAPHS or area chart - for aggregate department (groups) and/or individual 

For more in-depth data analysis, you can create reports as pivots. For example, you can look at the percentage of time spent in different statuses.

Dashboards gadgets feature will keep your finger on the pulse and track team productivity in real-time.

For Scrum teams we are also offering Sprint Report feature in Time in Status 

Add-on have 30-day free trial, free up to the 10 users and developed by my team. 

I hope you find this helpful 🚀 

[Mehmet A _Bloompeak_]

Hi @Hiromichi Kikuchi -san,

You can try Reports - Charts and Graphs for Jira app developed by our team to create various reports, charts and graphs for your Jira projects.

• You can create custom, flexible and colorful bar charts and table views for any data you want/need. As data source, you can choose Projects or Saved Filters or Advanced (JQL).

• You can set X axis to be any parameter like Created(month), Assignee, Sprint, Fix Versions etc.

• You can set Y axis to be any parameter like number of issues, sum of remaining estimates, average of story points etc.

• You can group your data on any field(Sprint, Status, Assignee, Component, Project etc.) you want.

• You can choose various date ranges like All Time, Last Year, Last 3 Months, Last 6 Months etc.

• You can modify existing Segments or add new segments.

• You can order the results by drag and drop.

Here is a sample report that shows sum of story points by resolution month and assignee.

Below you can see an article about creating custom reports, charts and graphs in Jira with our app.

How to Create Custom and Flexible Reports, Charts and Graphs in Jira

Here is our live demo dashboard where you can see and modify sample reports and play with them.

If you have any questions, feel free to schedule a demo with us.

Hope it helps.

[Amay Purohit_RVS]

Hi @Hiromichi Kikuchi 

For a complete solution for planning your projects, tracking the time in status and also time spent by your resources with multiple charts, dashboard gadgets options, try out our app.

Agile Tools

The main features of the app are as below :

Links/Epic Hierarchy :- View/Manage roll up for hierarchy (up to 10 levels), based on your Issue Links parent child relationship or standard Jira Epic Hierarchy.

Time in Status :- More than 20 types of Time in Status reports to track issues.

Worklogs Report :- Track time spent by resources with multiple filters / category / grouping features

Timesheets :- View/Enter your time spent for multiple days in easy to use Board/table views

The app is free for 10 users. Do try it out.

Disclaimer : I work for RVS, the vendor for this app

[Hannes Obweger - JXL for Jira]

Hi @Hiromichi Kikuchi

I think you'd really like the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

Except for graphs (which is something we want to add in the future, too), all of your requirements should be easy to fulfil using these features. I don't want to go into detail on each and every requirement here, but just to give you an overview, this is how JXL looks in action:

Note that this is just one of a virtually endless number of possible views and reports. You can freely define the fields you want to see, any number of grouping and hierarchy levels, etc. etc. etc.

Any questions just let me know,

Best,

Hannes

[Danut M _StonikByte_]

Hi @Hiromichi Kikuchi,

Have a look over the gadgets offered by our Great Gadgets app. It offers many gadgets that, for sure, will fill your requests in a large extent. 

Danut

[Hiromichi Kikuchi]

would this application be able to show me a list view with the hierarchy Epic, Story, Sub task?  

[Danut M _StonikByte_]

Hi @Hiromichi Kikuchi,

This app has a gadget named Work Break-Down Structure (WBS), which can display the issues from a filter, by their hierarchy Epics > Story > SubTask along with their status. 

All you have to do is to configure the gadget with a filter or JQL that returns the issues from your project, and it will do the grouping for you. If you want to display only issues from certain epics, then configure it with a JQL / filter like this:

parentEpic in (EPIC-1, EPIC-2, ...) 

Danut.