How to build a report that shows story points per statuses in sprint timeline

I’m new in EazyBi stuff, and I need repeat this report in using EazyBi

The idea here is to have a sum of story points per statuses in sprint timeline

Can anybody help me with this?

HI @Nick_Vasylevskyi,
Welcome to the eazyBI community! :slight_smile:

To create a report you are looking for you need to have Issue change history measures and do the following steps:

  1. Select Story Points History from Measure dimension.
  2. Add Time dimension in Rows at Day level.
  3. Sprint in Pages for filtering the needed Sprint
  4. Transition Status in Columns at Status level.
  5. Then switch to Bar chart and select Vertical and Stacked option from toolbox
  6. Don’t forget Nonempty in Rows and Hide empty coloumns.
    The end result would be like this:

If you are new at eazyBI stuff, we suggest checking our latest training videos that explain all main steps about report creation - data import, report creation and how to publish them -

Gerda //

Could you share the report definition for this? I tried to create following the steps but my time dimension shows future dates until 2022. The data seems to clean but I don’t understand how data shows on future days for a given active sprint. Thanks

Here is the report definition:

  "cube_name": "Issues",
  "cube_reports": [ {
     "name": "Story Point History per Transition Status",
     "result_view": "bar_chart",
     "definition": {"columns":{"dimensions":[{"name":"Measures","selected_set":["[Measures].[Story Points history]"],"members":[]},{"name":"Transition Status","selected_set":["[Transition Status].[Transition Status].Members"],"members":[],"bookmarked_members":[]}]},"rows":{"dimensions":[{"name":"Time","selected_set":["[Time].[Day].Members"],"members":[],"bookmarked_members":[]}],"nonempty_crossjoin":true},"pages":{"dimensions":[{"name":"Sprint","selected_set":["[Sprint].[All Sprints]"],"members":[{"depth":0,"name":"All Sprints","full_name":"[Sprint].[All Sprints]","drillable":true,"type":"all","expanded":true,"drilled_into":false},{"depth":1,"name":"D1 board","full_name":"[Sprint].[D1 board]","drillable":true,"expanded":true,"drilled_into":false,"parent_full_name":"[Sprint].[All Sprints]"},{"depth":2,"name":"D1 Sprint 3","full_name":"[Sprint].[D1 board].[D1 Sprint 3]","url_id":9,"url_sub_id":13,"parent_full_name":"[Sprint].[D1 board]"},{"depth":1,"name":"D4 board","full_name":"[Sprint].[D4 board]","drillable":true,"expanded":true,"drilled_into":false,"parent_full_name":"[Sprint].[All Sprints]"}],"bookmarked_members":[],"current_page_members":["[Sprint].[D1 board].[D1 Sprint 3]"]}]},"options":{"nonempty":true},"view":{"current":"bar_chart","maximized":false,"bar_chart":{"stacked":true,"vertical":true,"swap_axes":false,"data_labels":false,"series_options":{}},"table":{}},"calculated_members":[]}
  } ],
  "calculated_members": [{"name":"Story Points history","dimension":"Measures","format_string":"#,##0","formula":"Cache(\n  NonZero(Sum(PreviousPeriods([Time].CurrentHierarchyMember),\n    [Measures].[Story Points change]\n  ))\n  + [Measures].[Story Points change]\n)\n"}]

Adjust Page filter so it works for your sprints. Let me know if this works as expected now!