You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
Next: Root
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
The Atlassian Community can help you and your team get more value out of Atlassian products and practices.
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"}] }
Eli Solutions Team -Eli Solutions-
1 comment