Hi @gerda.grantina
Report definition below
{
“cube_name”: “Issues”,
“cube_reports”: [ {
“name”: “Effort spent on different issue types -NM2 - P\u0026L”,
“folder_name”: “New F”,
“result_view”: “pie_chart”,
“definition”: {“columns”:{“dimensions”:[{“name”:“Measures”,“selected_set”:[“[Measures].[Time spent within PI]”],“members”:[]}]},“rows”:{“dimensions”:[{“name”:“Issue Type”,“selected_set”:[“[Issue Type].[Story]”,“[Issue Type].[Bug]”,“[Issue Type].[Task]”],“members”:[],“bookmarked_members”:[{“depth”:1,“name”:“Story”,“full_name”:“[Issue Type].[Story]”},{“depth”:1,“name”:“Bug”,“full_name”:“[Issue Type].[Bug]”},{“depth”:1,“name”:“Task”,“full_name”:“[Issue Type].[Task]”}]}],“nonempty_crossjoin”:true},“pages”:{“dimensions”:[{“name”:“Fix Version”,“selected_set”:[“[Fix Version].[All Fix Versions]”,“[Fix Version].[TEST].[Unreleased].[PI 2022.1]”,“[Fix Version].[TEST].[Unreleased].[PI 2022.2]”],“members”:[{“depth”:0,“name”:“All Fix Versions”,“full_name”:“[Fix Version].[All Fix Versions]”,“drillable”:true,“type”:“all”,“expanded”:true,“drilled_into”:false,“removed”:true},{“depth”:3,“name”:“PI 2022.2”,“full_name”:“[Fix Version].[TEST].[Unreleased].[PI 2022.2]”,“url_id”:76670,“parent_key”:“MPDI”}],“bookmarked_members”:[{“depth”:3,“name”:“PI 2022.1”,“full_name”:“[Fix Version].[TEST].[Unreleased].[PI 2022.1]”,“url_id”:77752,“parent_key”:“MPDI”},{“depth”:3,“name”:“PI 2022.2”,“full_name”:“[Fix Version].[TEST].[Unreleased].[PI 2022.2]”,“url_id”:76670,“parent_key”:“MPDI”}],“current_page_members”:[“[Fix Version].[TEST].[Unreleased].[PI 2022.2]”]},{“name”:“Assigned Team”,“selected_set”:[“[Assigned Team].[Retail P\u0026C - MO]”,“[Assigned Team].[Retail P\u0026C –NM2]”,“[Assigned Team].[PF]”,“[Assigned Team].[ER]”,“[Assigned Team].[Retail P\u0026C – MR]”],“members”:[{“depth”:1,“name”:“Retail P\u0026C – MR”,“full_name”:“[Assigned Team].[Retail P\u0026C – MR]”}],“bookmarked_members”:[{“depth”:1,“name”:“Retail P\u0026C - MO”,“full_name”:“[Assigned Team].[Retail P\u0026C - MO]”},{“depth”:1,“name”:“Retail P\u0026C –NM2”,“full_name”:“[Assigned Team].[Retail P\u0026C –NM2]”},{“depth”:1,“name”:“ER”,“full_name”:“[Assigned Team].[ER]”},{“depth”:1,“name”:“Retail P\u0026C – MR”,“full_name”:“[Assigned Team].[Retail P\u0026C – MR]”}],“current_page_members”:[“[Assigned Team].[Retail P\u0026C – MR]”]}]},“options”:{“nonempty”:true},“view”:{“current”:“pie_chart”,“maximized”:false,“pie_chart”:{“swap_axes”:false,“donut”:true,“show_legend”:false,“show_labels”:true,“data_labels”:“values_percentage”,“relative_size”:false,“series_options”:{}},“table”:{}},“calculated_members”:[],“description”:“Effort spent on different tickets \n====================\nEffort spent in hours for different issue types for the PI”}
} ],
“calculated_members”: [{“dimension”:“Measures”,“name”:“Hours spent with sub-tasks”,“format_string”:“#,##0.00”,“formula”:“[Measures].[Hours spent] +\n[Measures].[Sub-tasks hours spent]”},{“dimension”:“Measures”,“name”:“Version start date”,“format_string”:“mmm dd yyyy”,“formula”:“CoalesceEmpty(\n [Affects Version].CurrentHierarchyMember.get(‘Start date’),\n [Fix Version].CurrentHierarchyMember.get(‘Start date’)\n)”},{“dimension”:“Measures”,“name”:“Version release date”,“format_string”:“mmm dd yyyy”,“formula”:“CoalesceEmpty(\n [Affects Version].CurrentHierarchyMember.get(‘Release date’),\n [Fix Version].CurrentHierarchyMember.get(‘Release date’)\n)”},{“name”:“Time within version”,“dimension”:“Measures”,“formula”:“CASE WHEN\n DateBetween([Time].CurrentHierarchyMember.StartDate,\n [Measures].[Version start date],\n [Measures].[Version release date]\n )\nTHEN 1\nEND”,“format_string”:“#,##0”},{“name”:“Time spent within PI”,“dimension”:“Measures”,“formula”:“Sum(Filter(\n Descendants([Time].CurrentHierarchyMember, [Time].[Day]),\n [Measures].[Time within version] \u003e 0\n), [Measures].[Hours spent with sub-tasks])”,“format_string”:“”}]
}
