Sure!
{
"cube_name": "Issues",
"cube_reports": [ {
"name": "SPEED - Flow Time",
"folder_name": "Success Framework,
"result_view": "bar_chart",
"definition": {"columns":{"dimensions":[{"name":"Measures","selected_set":["[Measures].[Median Issues Resolved working days]","[Measures].[Threshold Speed]"],"members":[{"depth":0,"full_name":"[Measures].[Median Issues Resolved working days]","format_string":"#,##0","report_specific":true,"name":"Median Issues Resolved working days","calculated":true},{"depth":0,"full_name":"[Measures].[Threshold Speed]","format_string":"#,##0","report_specific":true,"name":"Threshold Speed","calculated":true}]},{"name":"Transition Status","selected_set":["[Transition Status].[Flow Time]"],"members":[],"bookmarked_members":[]}]},"rows":{"dimensions":[{"name":"Time","selected_set":["[Time].[Last 2 Halfs ]"],"members":[{"depth":0,"name":"Last 2 Halfs ","full_name":"[Time].[Last 2 Halfs ]","annotations":{"group":"Half Year"},"calculated":true,"drillable":true,"expanded":true,"drilled_into":true},{"depth":0,"name":"Current Year H1","full_name":"[Time].[Current Year H1]","annotations":{"group":"Half Year"},"calculated":true,"drillable":true,"expanded":true,"drilled_into":false,"parent_full_name":"[Time].[Last 2 Halfs ]"},{"depth":2,"name":"Q1 2024","full_name":"[Time].[2024].[Q1 2024]","drillable":true,"expanded":true,"drilled_into":true,"parent_full_name":"[Time].[Current Year H1]"},{"depth":2,"name":"Q2 2024","full_name":"[Time].[2024].[Q2 2024]","drillable":true,"expanded":true,"drilled_into":true,"parent_full_name":"[Time].[Current Year H1]"},{"depth":0,"name":"Current Year H2","full_name":"[Time].[Current Year H2]","annotations":{"group":"Half Year"},"calculated":true,"drillable":true,"expanded":true,"drilled_into":false,"parent_full_name":"[Time].[Last 2 Halfs ]"},{"depth":2,"name":"Q3 2024","full_name":"[Time].[2024].[Q3 2024]","drillable":true,"expanded":true,"drilled_into":true,"parent_full_name":"[Time].[Current Year H2]"},{"depth":2,"name":"Q4 2024","full_name":"[Time].[2024].[Q4 2024]","drillable":true,"expanded":true,"drilled_into":true,"parent_full_name":"[Time].[Current Year H2]"}],"bookmarked_members":[]}],"nonempty_crossjoin":true},"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,"removed":false}],"bookmarked_members":[],"current_page_members":["[Project].[All Projects]"]},{"name":"Team(s)","selected_set":["[Team(s)].[All Team(s)s]"],"members":[{"depth":0,"name":"All Team(s)s","full_name":"[Team(s)].[All Team(s)s]","drillable":true,"type":"all","expanded":false,"drilled_into":false}],"bookmarked_members":[],"current_page_members":["[Team(s)].[All Team(s)s]"]},{"name":"Team","selected_set":["[Team].[All Teams]"],"members":[{"depth":0,"name":"All Teams","full_name":"[Team].[All Teams]","drillable":true,"type":"all"}],"bookmarked_members":[],"current_page_members":["[Team].[All Teams]"]},{"name":"Issue Type","selected_set":["[Issue Type].[Flow Items]","[Issue Type].[Flow Items + Tasks]","[Issue Type].[Other Items]"],"members":[{"depth":0,"name":"Flow Items","full_name":"[Issue Type].[Flow Items]","calculated":true,"drillable":true}],"bookmarked_members":[],"current_page_members":["[Issue Type].[Flow Items]"]},{"name":"Status","selected_set":["[Status].[Resolved and Closed]","[Status].[Only Status Closed]"],"members":[{"depth":0,"dimension":"Status","name":"Only Status Closed","formula":"[Status].[Closed]","format_string":"","full_name":"[Status].[Only Status Closed]","drillable":null,"annotations":null,"id":"[Status].[Only Status Closed]","calculated":true}],"bookmarked_members":[],"current_page_members":["[Status].[Only Status Closed]"]}]},"options":{},"view":{"current":"bar_chart","maximized":false,"bar_chart":{"stacked":false,"vertical":true,"swap_axes":false,"data_labels":true,"series_options":{"Median Issues Resolved working days":{"color":"#FFF2A4","dataLabelType":"top horizontal"},"Threshold Speed":{"color":"#D4153B","type":"line","dataLabelType":false},"Threshold Speed;Flow Time":{"type":"line","dataLabelType":false,"color":"#D4153B"},"Median Issues Resolved working days;Flow Time":{"color":"#FFF2A4","dataLabelType":"top horizontal"}},"x_axis":{"0":{"labelOrientation":"rotated"}},"show_full_caption":["Measures"]},"table":{}},"calculated_members":[{"dimension":"Measures","name":"Median Issues Resolved working days","formula":"NonZero(Median(\n Filter(\n Descendants([Issue].CurrentMember, [Issue].[Issue]),\n DateInPeriod(\n [Measures].[Issue resolution date],\n [Time].CurrentHierarchyMember\n )\n AND\n (\n [Measures].[Issue status] = \"Closed\" OR \n [Measures].[Issue status] = \"Resolved\"\n )\n AND (\n [Measures].[Issue resolution] = \"Fixed\"\n OR\n [Measures].[Issue resolution] = \"Done\"\n OR\n [Measures].[Issue resolution] = \"Configuration\"\n OR\n [Measures].[Issue resolution] = \"Ready\"\n \n ) AND\n ([Measures].[Issues created],\n [Time].CurrentHierarchy.DefaultMember,\n [Transition status].CurrentHierarchy.Defaultmember) \u003e 0),\n-- total time per cycle\n ([Measures].[Workdays in transition status],\n [Time].CurrentHierarchy.DefaultMember)\n )\n)","format_string":"#,##0"},{"dimension":"Measures","name":"Threshold Speed","formula":"10","format_string":"#,##0"}],"description":"## Area\n\nIt belongs to DELIVERY\n\n \n\u003cbr/\u003e\n \n\n\n## KPI definition\n\n**Flow time** is the median time for all tickets in a period based on the resolution date.\n\nThe time is calculated as the working days since the first time the tickets get In progress status until it's marked as Resolved or Closed.\n\n⚠ NOTE: [Median](https://en.wikipedia.org/wiki/Median) is not the average!\n\n \n\u003cbr/\u003e\n \n\n\n## Filters\n\nOn top, you can filter:\n\n* issue type\n* current status of the issue\n* resolution (done, fix, config and ready)"}
} ],
"calculated_members": [{"name":"Flow Items","dimension":"Issue Type","formula":"--annotations.group = Flow Framework\nAggregate({\n [Issue Type].[Defect],\n [Issue Type].[User Story],\n [Issue Type].[Improvement],\n [Issue Type].[Technical Debt],\n [Issue Type].[Risk]\n }\n)","format_string":""},{"dimension":"Measures","name":"Issue resolution date","format_string":"mmm dd yyyy","formula":"[Issue].CurrentHierarchyMember.get('Resolved at')"},{"dimension":"Measures","name":"Issue status","format_string":"","formula":"[Status].[Status].getMemberNameByKey(\n [Issue].CurrentHierarchyMember.get('Status ID')\n)"},{"dimension":"Measures","name":"Issue resolution","format_string":"","formula":"[Resolution].[Resolution].getMemberNameByKey(\n [Issue].CurrentHierarchyMember.get('Resolution ID')\n)"},{"name":"Flow Time","dimension":"Transition Status","formula":" [Transition Status].[In Progress]+\t\n [Transition Status].[Integration]+\t\n [Transition Status].[Reopened]+\t\n [Transition Status].[Ready for Review]+\n [Transition Status].[In Review]+\t\n [Transition Status].[Blocked]+\t\t\n [Transition Status].[Ready for Test]+\n [Transition Status].[In Test]+\t\n [Transition Status].[Resolved]+\n [Transition Status].[In Verification]+\n [Transition Status].[Deployment]","format_string":"#,##0"},{"name":"Resolved and Closed","dimension":"Status","formula":"Aggregate({\n[Status].[Resolved], \n[Status].[Closed]\n})","format_string":""},{"name":"Flow Items + Tasks","dimension":"Issue Type","formula":"-- annotations.group = Flow Framework\nAggregate({\n [Issue Type].[Defect],\n [Issue Type].[User Story],\n [Issue Type].[Improvement],\n [Issue Type].[Technical Debt],\n [Issue Type].[Risk],\n [Issue Type].[Task]\n}\n)","format_string":""},{"name":"Other Items","dimension":"Issue Type","formula":"Aggregate(\n Except(\n [Issue Type].[Issue Type].Members,\n {\n [Issue Type].[User Story],\n [Issue Type].[Improvement],\n [Issue Type].[Technical Debt],\n [Issue Type].[Defect],\n [Issue Type].[Risk],\n [Issue Type].[Task]\n }\n )\n)","format_string":""},{"name":"Current Year H1","dimension":"Time","formula":"--annotations.group = Half Year\nAggregate({\n [Time].[Quarter].DateMembersBetween('first day of the year', 'last day of June')\n})","format_string":""},{"name":"Current Year H2","dimension":"Time","formula":"--annotations.group = Half Year\nAggregate({\n [Time].[Quarter].DateMembersBetween(\n 'Jul 1 ' || [Time].[Year].CurrentDateMember.Name, \n 'Dec 31 '|| [Time].[Year].CurrentDateMember.Name\n )\n})","format_string":""},{"name":"Previous Year H2","dimension":"Time","formula":"--annotations.group = Half Year\nAggregate({\n [Time].[Quarter].DateMembersBetween(\n 'Jul 1 ' || [Time].[Year].CurrentDateMember.PrevMember.Name, \n 'Dec 31 '|| [Time].[Year].CurrentDateMember.PrevMember.Name\n )\n})","format_string":""},{"name":"Only Status Closed","dimension":"Status","formula":"[Status].[Closed]","format_string":""},{"name":"Last 2 Halfs ","dimension":"Time","formula":"--annotations.group= Half Year \nAggregate(\n Iif (\n DateBetween(\n Now(),\n [Time].[Year].CurrentDateMember.StartDate,\n DateParse('Jul 1 ' || [Time].[Year].CurrentDateMember.Name)\n ),\n\n {\n [Time].[Previous Year H2],\n [Time].[Current Year H1]\n }\n ,\n {\n [Time].[Current Year H1],\n [Time].[Current Year H2]\n }\n )\n)","format_string":""}]
}
If you want the definition of the whole dashboard, where we don’t have the “nonempty” for the page filters too. Let me know
