Analytics hub custom scrum burndown

[SeanServiceNow]

We have several agile assignment groups and several sprints we manage in SN.  The OOB dashboards do not show burndowns for all sprints, and would like to add a threshold so we can see when sprints go over capacity.  

1) Show all sprints in one report or analytics hub 

2) Set thresholds for the capacity for each sprint 

I can make a report that shows all the sprints, but cannot add thresholds.  When trying in analytics hub I'm not seeing any indicator source that would correspond with the data I would need to collect and creating one doesn't seem to be working either. 

Could you point me in the correct direction without forwarding me to a general overview of Performance Analytics please?  

[jstoessel]

In our Org - the ask was similar, and perhaps this might point you in a new direction.

I used the Sprint (rm_sprint) table and ran an analysis on:

• Sprint State is Current
• Sprint Total Committed Points
• Current Sprint Points
• Group Capacity (points)

Based on these fields - we were able to setup several different reports showing teams running OVERCOMMITTED, UNDERCOMMITTED - or JUST RIGHT

The report became known as the Agile Goldilocks report. 

Most of the formats for the dashboard widgets were Bar Charts with Line Charts overlaying to represent Committed vs Capacity or Current Points vs Capacity

Everyone wanted their own version 😉  The life of reporting

Hopefully, this might give you a nudge in a new direction.