Hey @zane.baranovska, thanks for your reply!
The report definition is below.
In the meantime, I think I may have resolved this issue. In the ‘Source Data’ section, I now also import the progress cycle for any issues with the ‘New’ status category (as well as those In Progress). It seems that this now imports the changes to the SLA (ie. breached/not breached) even when the issue remains in the New status.
I would be grateful if you could confirm whether this is the solution!
{
"cube_name": "Issues",
"cube_reports": [ {
"name": "Open issues by SLA (Breached / Not breached)",
"result_view": "bar_chart",
"definition": {"columns":{"dimensions":[{"name":"Measures","selected_set":["[Measures].[Open issues]"],"members":[]},{"name":"SLA Breached","selected_set":["[SLA Breached].[SLA Breached].Members"],"members":[],"bookmarked_members":[]}]},"rows":{"dimensions":[{"name":"Time","selected_set":["[Time.Weekly].[Last 12 weeks]"],"selected_set_expression":"DescendantsSet({{selected_set}}, [Time.Weekly].[Week])","members":[],"bookmarked_members":[]}]},"pages":{"dimensions":[{"name":"Time","duplicate":true,"selected_set":["[Time.Weekly].[All Times]","[Time.Weekly].[Last 12 months]","[Time.Weekly].[Last 6 months]","[Time.Weekly].[Last 12 weeks]","[Time.Weekly].[Last 8 weeks]","[Time.Weekly].[Last 4 weeks]"],"members":[{"depth":0,"name":"Last 12 weeks","full_name":"[Time.Weekly].[Last 12 weeks]","annotations":{"group":"Default","predefined":"true"},"dimension_hierarchy":"Weekly","calculated":true,"drillable":true,"dimension":"Time"}],"bookmarked_members":[],"current_page_members":["[Time.Weekly].[Last 12 weeks]"]}]},"options":{"total":"columns"},"view":{"current":"bar_chart","maximized":false,"bar_chart":{"stacked":true,"vertical":true,"swap_axes":false,"data_labels":"values_percentage","series_options":{"Breached":{"color":"#B31238"},"Not breached":{"color":"#376BB7"},"$total;$total":{"separateAxis":1,"type":"text","color":"#5E6C84","dataLabelType":"top horizontal"},"Open issues;Breached":{"color":"#006F92","dataLabelType":"middle horizontal"},"Open issues;Not breached":{"color":"#86DBA6","dataLabelType":"middle horizontal"}}},"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":"Last 12 months","dimension":"Time","dimension_hierarchy":"Weekly","formula":"Aggregate(\n [Time.Weekly].[Week].DateMembersBetween('1 year ago', 'today')\n)","format_string":""},{"dimension":"Time","name":"Last 4 weeks","format_string":"","formula":"Aggregate(\n [Time.Weekly].[Week].DateMembersBetween('4 weeks ago', 'today')\n)","dimension_hierarchy":"Weekly"},{"name":"Last 12 weeks","dimension":"Time","dimension_hierarchy":"Weekly","formula":"Aggregate(\n [Time.Weekly].[Week].DateMembersBetween('12 weeks ago', 'today')\n)","format_string":""},{"name":"Last 8 weeks","dimension":"Time","dimension_hierarchy":"Weekly","formula":"Aggregate(\n [Time.Weekly].[Week].DateMembersBetween('8 weeks ago', 'today')\n)","format_string":""},{"name":"Last 6 months","dimension":"Time","dimension_hierarchy":"Weekly","formula":"Aggregate(\n [Time.Weekly].[Week].DateMembersBetween('6 months ago', 'today')\n)","format_string":""}]
}