How to setup eazyBI to create a Sprint Velocity Chart
The post describing the report can be found here: community.eazybi.com/t/how-to...
Summary:
0:00 Intro and Overview
1:35 Setup eazyBI
3:50 Create the Sprint Velocity Chart
8:51 Add Report to a Jira's Dashboard
Export Definition:
{
"cube_name": "Issues",
"cube_reports": [ {
"name": "Sprint Velocity Chart",
"folder_name": "Agile Reports",
"result_view": "bar_chart",
"definition": {"columns":{"dimensions":[{"name":"Measures","selected_set":["[Measures].[Sprint Story Points committed]","[Measures].[Sprint Story Points completed]","[Measures].[Running Story Points velocity for 5 closed sprints]"],"members":null}]},"rows":{"dimensions":[{"name":"Sprint","selected_set":["[Sprint].[Sprint].Members"],"members":null,"bookmarked_members":null}],"filter_by":{"conditions":[{"expression":["[Measures].[Sprint Story Points committed]"],"operator":"\u003e","value":"0"}]}},"pages":{"dimensions":[{"name":"Project","selected_set":["[Project].[All Projects]"],"members":[{"depth":0,"name":"All Projects","full_name":"[Project].[All Projects]","drillable":true,"type":"all","expanded":true,"drilled_into":false},{"depth":1,"name":"Project Marvel ","full_name":"[Project].[Project Marvel ]","drillable":true,"key":"MARVEL","parent_full_name":"[Project].[All Projects]"}],"bookmarked_members":null,"current_page_members":["[Project].[Project Marvel ]"]}]},"options":{},"view":{"current":"bar_chart","maximized":false,"bar_chart":{"stacked":false,"vertical":true,"swap_axes":false,"data_labels":true,"series_options":{"Running Story Points velocity for 5 closed sprints":{"type":"line-Dash"},"Sprint Story Points completed":{"color":"#00B8D9"}},"x_axis":{"0":{"title":"Sprint"}},"y_axis":{"0":{"title":"Story Points"}}},"table":{}},"calculated_members":null}
} ],
"calculated_members": [{"name":"Sprint Story Points committed","dimension":"Measures","format_string":"#,##0.00","formula":"( [Measures].[Story Points added],
[Transition Field].[Sprint status],
[Sprint Status].[Active],
- An issue was in a sprint at a sprint start time
[Issue Sprint Status Change].[Future =\u003e Active]
)
"},{"name":"Sprint Story Points at closing","dimension":"Measures","format_string":"#,##0.00","formula":"- Story points from issues when a sprint was closed
( [Measures].[Story Points added],
[Transition Field].[Sprint status],
[Sprint Status].[Closed],
[Issue Sprint Status Change].[Active =\u003e Closed]
)
"},{"name":"Sprint Story Points completed","dimension":"Measures","format_string":"#,##0.00","formula":"(
[Measures].[Sprint Story Points at closing],
[Transition Status.Category].[Done]
)
"},{"name":"Running Story Points velocity for 5 closed sprints","dimension":"Measures","format_string":"#,##0.00","formula":"CASE
WHEN
[Sprint].CurrentHierarchyMember.Level.Name = 'Sprint' AND
[Sprint].CurrentHierarchyMember.GetBoolean('Closed')
THEN
AVG(
Tail(
Filter(
-- filter last 5 previous sprints in a board starting from current sprint
[Sprint].CurrentHierarchyMember.FirstSibling:
[Sprint].CurrentHierarchyMember,
[Sprint].CurrentHierarchyMember.GetBoolean('Closed')
),
-- set the count of last closed sprints for running velocity
5 ) ,
[Measures].[Sprint Story Points completed]
)
END
"}]
}