I’m looking to create a burndown chart of all the epics. Our epics use t-shirt sizes, and I’ve converted t-shirt sizes into numerical values using javascript in the import i.e XL = 64, L =32 etc.
Where I’m having trouble is aggregating those values into a single value:
As you can see, the values are broken into the numbers I’ve converted to. I’m wondering if there’s a way to aggregate those values together?
Thanks for your consideration!
{
“cube_name”: “Issues”,
“cube_reports”: [ {
“name”: “Epic T-Shirt Milestone Burndown”,
“folder_name”: “FBG Agile Reports”,
“result_view”: “bar_chart”,
“definition”: {“columns”:{“dimensions”:[{“name”:“Measures”,“selected_set”:[“[Measures].[Total Epic Story Points]”],“members”:[]},{“name”:“Estimate value”,“selected_set”:[“[Estimate value].[All Estimate values]”],“members”:[{“depth”:0,“name”:“All Estimate values”,“full_name”:“[Estimate value].[All Estimate values]”,“drillable”:true,“type”:“all”,“expanded”:true,“drilled_into”:false,“removed”:true},{“depth”:1,“name”:“(none)”,“full_name”:“[Estimate value].[(none)]”,“removed”:true,“parent_full_name”:“[Estimate value].[All Estimate values]”}],“bookmarked_members”:[]}]},“rows”:{“dimensions”:[{“name”:“Time”,“selected_set”:[“[Time.Weekly].[Day].Members”],“members”:[],“bookmarked_members”:[]}],“filter_by”:{“conditions”:[{“expression”:“[Time].CurrentHierarchyMember”,“operator”:“between”,“value”:“10/21/2022,11/30/2022”,“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”}],“bookmarked_members”:[],“current_page_members”:[“[Project].[All Projects]”]},{“name”:“Target end dimension”,“selected_set”:[“[Target end dimension].[All Target end dimensions]”],“members”:[{“depth”:0,“name”:“All Target end dimensions”,“full_name”:“[Target end dimension].[All Target end dimensions]”,“drillable”:true,“type”:“all”,“expanded”:true,“drilled_into”:false},{“depth”:1,“name”:“2022-10-26”,“full_name”:“[Target end dimension].[2022-10-26]”,“parent_full_name”:“[Target end dimension].[All Target end dimensions]”},{“depth”:1,“name”:“2022-10-28”,“full_name”:“[Target end dimension].[2022-10-28]”,“parent_full_name”:“[Target end dimension].[All Target end dimensions]”},{“depth”:1,“name”:“2022-10-31”,“full_name”:“[Target end dimension].[2022-10-31]”,“parent_full_name”:“[Target end dimension].[All Target end dimensions]”},{“depth”:1,“name”:“2022-11-02”,“full_name”:“[Target end dimension].[2022-11-02]”,“parent_full_name”:“[Target end dimension].[All Target end dimensions]”},{“depth”:1,“name”:“2022-11-04”,“full_name”:“[Target end dimension].[2022-11-04]”,“parent_full_name”:“[Target end dimension].[All Target end dimensions]”},{“depth”:1,“name”:“2022-11-09”,“full_name”:“[Target end dimension].[2022-11-09]”,“parent_full_name”:“[Target end dimension].[All Target end dimensions]”},{“depth”:1,“name”:“2022-11-14”,“full_name”:“[Target end dimension].[2022-11-14]”,“parent_full_name”:“[Target end dimension].[All Target end dimensions]”},{“depth”:1,“name”:“2022-11-16”,“full_name”:“[Target end dimension].[2022-11-16]”,“parent_full_name”:“[Target end dimension].[All Target end dimensions]”},{“depth”:1,“name”:“2022-11-21”,“full_name”:“[Target end dimension].[2022-11-21]”,“parent_full_name”:“[Target end dimension].[All Target end dimensions]”},{“depth”:1,“name”:“2022-11-28”,“full_name”:“[Target end dimension].[2022-11-28]”,“parent_full_name”:“[Target end dimension].[All Target end dimensions]”},{“depth”:1,“name”:“2022-11-30”,“full_name”:“[Target end dimension].[2022-11-30]”,“parent_full_name”:“[Target end dimension].[All Target end dimensions]”},{“depth”:1,“name”:“2022-11-23”,“full_name”:“[Target end dimension].[2022-11-23]”,“parent_full_name”:“[Target end dimension].[All Target end dimensions]”}],“bookmarked_members”:[],“current_page_members”:[“[Target end dimension].[2022-10-26]”,“[Target end dimension].[2022-10-28]”,“[Target end dimension].[2022-10-31]”,“[Target end dimension].[2022-11-02]”,“[Target end dimension].[2022-11-04]”,“[Target end dimension].[2022-11-09]”,“[Target end dimension].[2022-11-14]”,“[Target end dimension].[2022-11-16]”,“[Target end dimension].[2022-11-21]”,“[Target end dimension].[2022-11-23]”,“[Target end dimension].[2022-11-28]”,“[Target end dimension].[2022-11-30]”]},{“name”:“Commitment Status”,“selected_set”:[“[Commitment Status].[All Commitment Statuses]”],“members”:[{“depth”:0,“name”:“All Commitment Statuses”,“full_name”:“[Commitment Status].[All Commitment Statuses]”,“drillable”:true,“type”:“all”,“expanded”:true,“drilled_into”:false}],“bookmarked_members”:[],“current_page_members”:[“[Commitment Status].[All Commitment Statuses]”]},{“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”:“Epic”,“full_name”:“[Issue Type].[Epic]”,“parent_full_name”:“[Issue Type].[All Issue Types]”}],“bookmarked_members”:[],“current_page_members”:[“[Issue Type].[Epic]”]}]},“options”:{“total”:“columns”},“view”:{“current”:“bar_chart”,“maximized”:false,“bar_chart”:{“stacked”:true,“vertical”:true,“swap_axes”:false,“data_labels”:false,“series_options”:{“0”:{“color”:“#2F579C”},“16”:{“color”:“#2F579C”},“32”:{“color”:“#2F579C”},“48”:{“color”:“#2F579C”},“64”:{“color”:“#2F579C”},“$total;$total”:{“type”:“line”,“color”:“#FFD04D”,“symbol”:false},“Open Epics Today;64”:{“color”:“#DEEBFF”},“Open Epics Today;48”:{“color”:“#B3D4FF”},“Open Epics Today;32”:{“color”:“#7CA7E5”},“Open Epics Today;16”:{“color”:“#5A89CE”},“Total Epic Story Points;16”:{“color”:“#2F579C”},“Total Epic Story Points;32”:{“color”:“#2F579C”},“Total Epic Story Points;0”:{“color”:“#2F579C”},“Total Epic Story Points;48”:{“color”:“#2F579C”},“Total Epic Story Points;64”:{“color”:“#2F579C”}},“x_axis”:{“0”:{“title”:“11/30 Ready For Launch”}},“y_axis”:{“0”:{“title”:“Story Points”}}},“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 Cache([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”:“Total Epic Story Points”,“dimension”:“Measures”,“formula”:“Case WHEN\n DateAfterPeriodEnd(‘tomorrow’,[Time].CurrentHierarchyMember)\nTHEN\n– [Measures].[Open issues] * [Estimate value].CurrentMember.Value\n Case [Estimate value].CurrentMember.Key\n WHEN "16" THEN [Measures].[Open issues] * 16\n WHEN "32" THEN [Measures].[Open issues] * 32\n WHEN "48" THEN [Measures].[Open issues] * 48\n WHEN "64" THEN [Measures].[Open issues] * 64\n END\nEND”,“format_string”:“”}]
}