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

Questions & Answers
,
1

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

image
image974×417 6.55 KB

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

Can anybody help me with this?

2

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:
    story-points
    story-points2816×1218 209 KB

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 - https://docs.eazybi.com/eazybijira/learn-more/training-videos

best,
Gerda // support@eazyBI.com

3

Hi,
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

4

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!

best,
Gerda