Help required to create a Dashboard

[zakathuria]

Hello Team,

Please could you assist with the creation of dashboard for the following items

Defect Detection trend -- # of defects raised per day (by severity)
- Impt fields are: Creation/Detection date and Severity

Defect Fix trend -- # of defects fixed per day -- this should also show the actual defect resolution time vs Defect Resolution SLA
Have a cut by severity
- Impt fields are: Date of fixed/resolution, Severity, Defect Status
Also provide me the Defect Severity SLA

Open defects graph/trend -- # of open defects per day (by severity)
- Impt fields are: Severity, Defect Status

Closed and Deferred defects graph/table -- to see how many defects are we deferring to the next sprint -- note that we need these data so both devs and testers can properly plan out the impact of deferring the defect fixes to the next sprint
- Impt fields are: Defect Status

Invalid Defects (graph/table) -- this is for us to see if there are improvements on test execution/planning/defect reporting that we need to address (since this means that defects reported are not valid)
- Impt fields are: Defect Status or RCA Category (dont know how we track invalid defects)

thanks 

[Chris Buzon · Accepted solution]

Hi zakathuria 

This is actually quite a lot of work, and mostly it's going to require experimentation with widgets and JQL queries to get the results you want. 

There are a number of add-ons you can get on the marketplace that will make this easier, but you'll be limited to only a few out-of-the-box solutions that have limited graphing options.  

Alternatively, you can look to partners like Adaptavist who can do this sort of work for you.  

[Bill Sheboy]

Hi @zakathuria 

Yes, and... to what @Chris Buzon suggests, I recommend you pause and have a discussion with the team about that information as it seems like quite a lot.

Specifically, "what would you do/improve/act differently right now if you had piece of data <X>?"  If you cannot answer the question please consider if you need a measure now or if it can be deferred, as that may save you some up-front work building a dashboard.

Best regards,

Bill

[zakathuria]

Thanks @Bill Sheboy @Chris Buzon

We have piece of data where we can play around, is it ok if we can get a support for few items.

Thanks,

Avinash Singh 

[Bill Sheboy]

Hi @zakathuria 

Sorry, I wasn't trying to discourage you from trying this dashboarding.  Please ask what you wish.  I was noting that with so many measures, your team may get overwhelmed building those and then trying to respond to them.

Think of a hypothetical example where you get a new electronics device with no user manual and none of the controls are labeled. You could change all the controls at once with lots of responses, and you wouldn't know what caused the impacts.  However, if you turn one dial at a time, you can see more clearly what happens and why.

Best regards,

Bill

[Chris Buzon]

To second what Bill said, I am also not trying to discourage you - buy maybe instead get you to approach this a bit differently. 

A good place to start from your list maybe be the defects per day, since that has an out of the box solution that might work for you.

- There are two Atlassian widgets that can get you that (Created vs Resolved Chart, and Recently Created Chart) - They allow you to specify a project or a JQL query - and they can be configured per day/week/month/quarter/year
You could try just pointing those widgets at the projects and see if it's showing you what you're expecting. If it's too much data you can improve the JQL query to remove anything unexpected (that may be easy, or complicated, depending on the setup of your instance)

The invalid defects one, for example, is going to be pretty hard for anyone to help with if you don't know how invalid defects are tracked.  My company uses a status/resolution pair for that, but you may do something more complicated.  
If you're using fairly standard bug type workflows, that may just be a report (Issue Statistics widget) that is formed something like project = X and statuscategory = DONE and resolution in (duplicate, WNF, NaB) 

[Gorka Puente _Appfire_]

Hi @zakathuria

We provide one of the commercial apps that @Chris Buzon refers to: Dashboard Hub for Jira. It comes with different pre-defined dashboard templates where you'll find metrics and charts depending on the category: ITSM, DevOps, Agile... and you can always use any of the more than 60 provided gadgets, or set up your own custom charts. See this live demos: ITSM dashboard or Agile Team dashboard. Regards