How to create a Burn-up per my Program Increment

Questions & Answers
1

Hi EazyBI.

I need to create a classical burn up in eazybi for my program increment. In the program increment we have a list of epics. And I would like to see the total account of issues in this epics and how they close week by week. And the timeline I need to be the calendar quarter. Now we are doing it for Q2 calendar year 25.

Screenshot 2025-04-01 at 15.18.34
Screenshot 2025-04-01 at 15.18.341754×652 31.1 KB

2

So first need to find our how I select all the work items created under these selected epics, and then to use measures such us total created, total resolved on a week by week basis. This would be very useful

3

I have something like the report bellow. But I have no idea how to select the work for the epics where program increment is “CY25Q2”. And I would also like to display on the chart from where we start what is the total count in the beginning. Thank you for considering this.

4

{
“cube_name”: “Issues”,
“cube_reports”: [ {
“name”: “Burn-Up Program Increment”,
“folder_name”: “Program Increment”,
“result_view”: “timeline_chart”,
“definition”: {“columns”:{“dimensions”:[{“name”:“Measures”,“selected_set”:[“[Measures].[Open issues]”],“members”:}]},“rows”:{“dimensions”:[{“name”:“Time”,“selected_set”:[“[Time.Weekly].[Week].Members”],“members”:,“bookmarked_members”:}],“filter_by”:{“conditions”:[{“expression”:“[Time.Weekly].CurrentHierarchyMember”,“operator”:“between”,“value”:“April 2 2025, June 2 2025”,“value_type”:“date”}]}},“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”:“TrialMax”,“full_name”:“[Project].[TrialMax]”,“drillable”:true,“key”:“TMAX”,“parent_full_name”:“[Project].[All Projects]”}],“bookmarked_members”:,“current_page_members”:[“[Project].[TrialMax]”]},{“name”:“Issue Type”,“selected_set”:[“[Issue Type].[All Issue Types]”],“members”:[{“depth”:0,“name”:“All Issue Types”,“full_name”:“[Issue Type].[All Issue Types]”,“drillable”:true,“type”:“all”,“expanded”:true,“drilled_into”:false},{“depth”:1,“name”:“Bug”,“full_name”:“[Issue Type].[Bug]”,“parent_full_name”:“[Issue Type].[All Issue Types]”},{“depth”:1,“name”:“Incident”,“full_name”:“[Issue Type].[Incident]”,“parent_full_name”:“[Issue Type].[All Issue Types]”},{“depth”:1,“name”:“Story”,“full_name”:“[Issue Type].[Story]”,“parent_full_name”:“[Issue Type].[All Issue Types]”},{“depth”:1,“name”:“Task”,“full_name”:“[Issue Type].[Task]”,“parent_full_name”:“[Issue Type].[All Issue Types]”}],“bookmarked_members”:,“current_page_members”:[“[Issue Type].[Bug]”,“[Issue Type].[Incident]”,“[Issue Type].[Story]”,“[Issue Type].[Task]”]},{“name”:“Program Increment”,“selected_set”:[“[Program Increment].[All Program Increments]”],“members”:[{“depth”:0,“name”:“All Program Increments”,“full_name”:“[Program Increment].[All Program Increments]”,“drillable”:true,“type”:“all”,“expanded”:true,“drilled_into”:false},{“depth”:1,“name”:“CY25Q2”,“full_name”:“[Program Increment].[CY25Q2]”,“parent_full_name”:“[Program Increment].[All Program Increments]”}],“bookmarked_members”:,“current_page_members”:[“[Program Increment].[CY25Q2]”]}]},“options”:{},“view”:{“current”:“timeline_chart”,“maximized”:false,“timeline_chart”:{“series_type”:“line”,“series_options”:{}},“table”:{}},“calculated_members”:}
} ],
“calculated_members”: [{“dimension”:“Measures”,“name”:“Open issues”,“format_string”:“#,##0”,“formula”:“CASE WHEN [Issue].CurrentMember.Level.Name \u003c\u003e ‘Issue’ THEN\n Cache(\n NonZero(Sum(PreviousPeriods([Time].CurrentHierarchyMember),\n [Measures].[Issues created]\n - [Measures].[Issues resolved]\n ))\n + [Measures].[Issues created]\n - [Measures].[Issues resolved]\n )\nWHEN [Time].CurrentHierarchyMember IS [Time].CurrentHierarchy.DefaultMember\nTHEN NonZero([Measures].[Issues due])\nELSE\n – optimized formula for drill through Issue\n NonZero(IIF(\n DateBeforePeriodEnd(\n [Issue].CurrentMember.get(‘Created at’),\n [Time].CurrentHierarchyMember) AND\n NOT DateBeforePeriodEnd(\n [Issue].CurrentMember.get(‘Resolved at’),\n [Time].CurrentHierarchyMember),\n ([Time].CurrentHierarchy.DefaultMember,\n [Measures].[Issues created]),\n 0\n ))\nEND”}]
}

5

or this one, but I am unable to see issues created, to build a burn up instead of a burn down

{
“cube_name”: “Issues”,
“cube_reports”: [ {
“name”: “Burn-Up Program Increment”,
“folder_name”: “Program Increment”,
“result_view”: “line_chart”,
“definition”: {“columns”:{“dimensions”:[{“name”:“Measures”,“selected_set”:[“[Measures].[Open issues]”,“[Measures].[Today]”,“[Measures].[Issues resolved]”,“[Measures].[Cumulative Issues resolved]”],“members”:}]},“rows”:{“dimensions”:[{“name”:“Time”,“selected_set”:[“[Time.Weekly].[Week].Members”],“members”:,“bookmarked_members”:}],“filter_by”:{“conditions”:[{“expression”:“[Time.Weekly].CurrentHierarchyMember”,“operator”:“between”,“value”:“march 31 2025, June 2 2025”,“value_type”:“date”}]}},“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”:“TrialMax”,“full_name”:“[Project].[TrialMax]”,“drillable”:true,“key”:“TMAX”,“parent_full_name”:“[Project].[All Projects]”}],“bookmarked_members”:,“current_page_members”:[“[Project].[TrialMax]”]},{“name”:“Issue Type”,“selected_set”:[“[Issue Type].[All Issue Types]”],“members”:[{“depth”:0,“name”:“All Issue Types”,“full_name”:“[Issue Type].[All Issue Types]”,“drillable”:true,“type”:“all”,“expanded”:true,“drilled_into”:false},{“depth”:1,“name”:“Bug”,“full_name”:“[Issue Type].[Bug]”,“parent_full_name”:“[Issue Type].[All Issue Types]”},{“depth”:1,“name”:“Story”,“full_name”:“[Issue Type].[Story]”,“parent_full_name”:“[Issue Type].[All Issue Types]”},{“depth”:1,“name”:“Task”,“full_name”:“[Issue Type].[Task]”,“parent_full_name”:“[Issue Type].[All Issue Types]”}],“bookmarked_members”:,“current_page_members”:[“[Issue Type].[Bug]”,“[Issue Type].[Story]”,“[Issue Type].[Task]”]},{“name”:“Program Increment”,“selected_set”:[“[Program Increment].[All Program Increments]”],“members”:[{“depth”:0,“name”:“All Program Increments”,“full_name”:“[Program Increment].[All Program Increments]”,“drillable”:true,“type”:“all”,“expanded”:true,“drilled_into”:false},{“depth”:1,“name”:“CY25Q2”,“full_name”:“[Program Increment].[CY25Q2]”,“parent_full_name”:“[Program Increment].[All Program Increments]”}],“bookmarked_members”:,“current_page_members”:[“[Program Increment].[CY25Q2]”]}]},“options”:{},“view”:{“current”:“line_chart”,“maximized”:false,“line_chart”:{“area”:false,“swap_axes”:false,“data_labels”:false,“series_options”:{“Open issues”:{“dataLabelType”:“top horizontal”,“color”:“#79E2F2”},“Today”:{“type”:“plotline”,“color”:“#B3BAC5”,“dataLabelType”:“top horizontal”},“Issues resolved”:{“color”:“#5DC48B”,“type”:“column”},“Cumulative Issues resolved”:{“color”:“#5DC48B”}}},“table”:{}},“calculated_members”:}
} ],
“calculated_members”: [{“dimension”:“Measures”,“name”:“Open issues”,“format_string”:“#,##0”,“formula”:“CASE WHEN [Issue].CurrentMember.Level.Name \u003c\u003e ‘Issue’ THEN\n Cache(\n NonZero(Sum(PreviousPeriods([Time].CurrentHierarchyMember),\n [Measures].[Issues created]\n - [Measures].[Issues resolved]\n ))\n + [Measures].[Issues created]\n - [Measures].[Issues resolved]\n )\nWHEN [Time].CurrentHierarchyMember IS [Time].CurrentHierarchy.DefaultMember\nTHEN NonZero([Measures].[Issues due])\nELSE\n – optimized formula for drill through Issue\n NonZero(IIF(\n DateBeforePeriodEnd(\n [Issue].CurrentMember.get(‘Created at’),\n [Time].CurrentHierarchyMember) AND\n NOT DateBeforePeriodEnd(\n [Issue].CurrentMember.get(‘Resolved at’),\n [Time].CurrentHierarchyMember),\n ([Time].CurrentHierarchy.DefaultMember,\n [Measures].[Issues created]),\n 0\n ))\nEND”},{“name”:“Cumulative Issues resolved”,“dimension”:“Measures”,“formula”:“Cache(\n Sum({PreviousPeriods([Time].CurrentHierarchyMember),\n [Time].CurrentHierarchyMember},\n [Measures].[Issues resolved]\n )\n)\n”,“format_string”:“”},{“name”:“Today”,“dimension”:“Measures”,“formula”:“Case WHEN\nDateInPeriod(\n’today’,\n[Time].CurrentHierarchyMember\n)\nTHEN\n"Today"\nEND”,“format_string”:“#,##0”}]
}

6

I would like the burn down line or burn up to not continue for weeks in the future but to remain in the current timeline. I need I think cumulative created and closed items overtime

7

Hi, @Ionut-Adrian_Bejenar

Welcom to the eazyBI community.

Not sure how far you are with your report, but answering the final question, the pseudo code for the measure might look something like this:

Case when
  -- show any past periods
  DateAfterPeriodEnd(
    "Today",
    [Time].CurrentHierarchyMember)
  OR 
  -- show the current period
  DateInPeriod(
    "Today",
    [Time].CurrentHierarchyMember
  )
Then
[Measures].[your measure]
End

If you need further assistance with a report, please write us to the support@eazybi.com

Kindly,
Ilze