Hi am having a list of epics selected for the teams to complete in the next quarter. These epics have an attribute “program increment” and then a value for this. I want to select all the work available for these epics and present them in a chart. I can manually update child epics with the same program increment value, but I am wondering if there is other way.
here si the chart
{
“cube_name”: “Issues”,
“cube_reports”: [ {
“name”: “PI Burn-Down”,
“folder_name”: “Program Increment”,
“result_view”: “line_chart”,
“definition”: {“columns”:{“dimensions”:[{“name”:“Measures”,“selected_set”:[“[Measures].[Cumulative Issues Closed]”,“[Measures].[Issues created]”,“[Measures].[Open issues]”,“[Measures].[Today]”,“[Measures].[Issues closed]”],“members”:}]},“rows”:{“dimensions”:[{“name”:“Time”,“selected_set”:[“[Time.Weekly].[Day].Members”],“members”:,“bookmarked_members”:}],“filter_by”:{“conditions”:[{“expression”:“[Time.Weekly].CurrentHierarchyMember”,“operator”:“between”,“value”:“April 3 2025, July 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”:“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].[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”:false,“color”:“#79E2F2”,“symbol”:false},“Today”:{“type”:“plotline”,“color”:“#B3BAC5”,“dataLabelType”:“top horizontal”},“Issues resolved”:{“color”:“#5DC48B”,“type”:“column”},“Cumulative Issues resolved”:{“color”:“#5DC48B”},“Issues created”:{“color”:“#7CA7E5”,“type”:“column”,“dataLabelType”:“top horizontal”},“Cumulative Issues Closed”:{“color”:“#5DC48B”,“type”:“area”,“symbol”:false},“Issues closed”:{“type”:“column”,“color”:“#34AD70”}}},“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”:“Today”,“dimension”:“Measures”,“formula”:“Case WHEN\nDateInPeriod(\n’today’,\n[Time].CurrentHierarchyMember\n)\nTHEN\n"Today"\nEND”,“format_string”:“#,##0”},{“name”:“Cumulative Issues Closed”,“dimension”:“Measures”,“formula”:“Cache(\n Sum({PreviousPeriods([Time].CurrentHierarchyMember),\n [Time].CurrentHierarchyMember},\n [Measures].[Issues closed]\n )\n)”,“format_string”:“”}]
}