🍻🍂Apptoberfest🍂🍻: Agile Reporting with eazyBI - Part 1 - Sprint Velocity Chart

Phonto.jpg

Overview
In this video you can find a complete walkthrough on how you can create your first Sprint Velocity Chart with EazyBI:  Video Tutorial Link 

Export Definition

If you are an existing eazyBI user feel free to use the export definition below and import it to your eazyBI instance. 

 { "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],\n [Transition Field].[Sprint status],\n [Sprint Status].[Active],\n -- An issue was in a sprint at a sprint start time\n [Issue Sprint Status Change].[Future =\u003e Active]\n)\n"},{"name":"Sprint Story Points at closing","dimension":"Measures","format_string":"#,##0.00","formula":"-- Story points from issues when a sprint was closed\n( [Measures].[Story Points added],\n [Transition Field].[Sprint status],\n [Sprint Status].[Closed],\n [Issue Sprint Status Change].[Active =\u003e Closed]\n)\n"},{"name":"Sprint Story Points completed","dimension":"Measures","format_string":"#,##0.00","formula":"(\n [Measures].[Sprint Story Points at closing],\n [Transition Status.Category].[Done]\n)\n"},{"name":"Running Story Points velocity for 5 closed sprints","dimension":"Measures","format_string":"#,##0.00","formula":"CASE\n WHEN\n [Sprint].CurrentHierarchyMember.Level.Name = 'Sprint' AND\n [Sprint].CurrentHierarchyMember.GetBoolean('Closed')\n THEN\n AVG(\n Tail(\n Filter(\n -- filter last 5 previous sprints in a board starting from current sprint\n [Sprint].CurrentHierarchyMember.FirstSibling:\n [Sprint].CurrentHierarchyMember,\n [Sprint].CurrentHierarchyMember.GetBoolean('Closed')\n ),\n -- set the count of last closed sprints for running velocity\n 5 ) ,\n [Measures].[Sprint Story Points completed]\n )\nEND\n"}] }

1 comment

Comment

Log in or Sign up to comment
Huwen Arnone
Solutions Partner
Solution Partners provide consulting, sales, and technical services on Atlassian products.
October 7, 2021

This is probably too technical for me, but I understand what it solves. And, well... eazyBI is a fantastic solution for reporting. I subscribed to your YouTube channel!!

Like # people like this
TAGS
AUG Leaders

Atlassian Community Events