I'm looking to setup a widget on a dashboard that will calculate both the velocity and number of issues over the past five sprints and then load that data into a widget on a dashboard. ex. below
Project A - velocity over last 5 sprints is 55, total average of issues over last 5 sprints is 35
Project B - velocity over last 5 sprints is 40, total average of issues over last 5 sprints is 60
Project C - velocity over last 5 sprints is 88, total average of issues over last 5 sprints is 77
I know I will need to use scriptrunner for this but am not sure how to setup the JQL to capture this or which widget would be best to display this information on a dashboard.