Need help with dashboard that shows Sprint, Assignee, Dev start date and Dev End Date

Question

Hi Folks,

I have a new requirement from one of my esteemed clients. They want me to show a dashboard view which has the data Sprint Name, How many tickets assigned to whom, Dev Start Date and Dev End Date.

Dev Start Date and Dev End Date are custom fields.

Can you suggest a filter query which can help to display above data.

Danut M _StonikByte_ · Answer

Hi @Vishal Gogari ,

With the Pivot Table & Pivot Chart gadget offered by our Great Gadgets app, you can easily display statistics with issues assigned by assignee on each sprint, like this:

You can also generate this statistic by story points, instead of issue count, if you want.

As @Kavitha Chandrasekaran mentioned, adding Dev Start Date and Dev End Date is not possible (actually, with this gadget is possible, but it makes no sense), because that it is a per-issue field. If you want that, you could eventually use the Filter Results gadget of Jira to list the issues from sprint along with those fields.

If you have any questions, feel free to contact us at support@stonikbyte.com; we would be more than happy to assist you with the configuration of this gadget.

Hope this helps.

Danut.

Kavitha Chandrasekaran · Answer

Is you do how many tickets assigned to whom, then you can't do Dev start and end date because that info is for each ticket.

If you want to do how many tickets assigned to whom, you can do a query for current sprint and use a pie chart widget to group by assignee. Quite simple.