I have a report (definition below) that was once working fine. We recently changed migrations and I am now filtering out SOME issues that bubbled up super old issues as being recently resolved. In refactoring the reports I wanted to change the calculations to not even can about resolution data and rather look at issue closed date. I updated the measures and still get no data populating.
{
“cube_name”: “Issues”,
“cube_reports”: [ {
“name”: “Open Issues Days Overview by Current Status”,
“folder_name”: “Agile Metrics”,
“result_view”: “table”,
“definition”: {“columns”:{“dimensions”:[{“name”:“Measures”,“selected_set”:["[Measures].[Status last updated less than 8 days ago]","[Measures].[Status last update 8-14 days ago]","[Measures].[Status last updated more than 14 days ago]","[Measures].[Average days in current status]"],“members”:null}]},“rows”:{“dimensions”:[{“name”:“Status”,“selected_set”:["[Status.Category].[Status].Members"],“members”:[{“depth”:2,“name”:“Done”,“full_name”:"[Status.Category].[Done].[Done]",“removed”:true},{“depth”:2,“name”:“Deployed”,“full_name”:"[Status.Category].[Done].[Deployed]",“removed”:true}],“bookmarked_members”:null}],“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},{“depth”:1,“name”:“Health Markets Analytics”,“full_name”:"[Project].[Health Markets Analytics]",“drillable”:true,“key”:“HMA”,“parent_full_name”:"[Project].[All Projects]"}],“bookmarked_members”:null,“current_page_members”:["[Project].[Health Markets Analytics]"]},{“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”:“Task”,“full_name”:"[Issue Type].[Task]",“parent_full_name”:"[Issue Type].[All Issue Types]"},{“depth”:1,“name”:“Story”,“full_name”:"[Issue Type].[Story]",“parent_full_name”:"[Issue Type].[All Issue Types]"},{“depth”:1,“name”:“Bug”,“full_name”:"[Issue Type].[Bug]",“parent_full_name”:"[Issue Type].[All Issue Types]"},{“depth”:1,“name”:“TIO Task”,“full_name”:"[Issue Type].[TIO Task]",“parent_full_name”:"[Issue Type].[All Issue Types]"}],“bookmarked_members”:null,“current_page_members”:["[Issue Type].[Task]","[Issue Type].[Story]","[Issue Type].[Bug]","[Issue Type].[TIO Task]"]}]},“options”:{},“view”:{“current”:“table”,“maximized”:false,“table”:{“row_dimension_headers”:{“Status”:“Current Status”},“cell_formatting”:{"[Measures].[Status last updated less than 8 days ago]":[{“background_color”:"#00875A"}],"[Measures].[Status last update 8-14 days ago]":[{“background_color”:"#FFBE60"}],"[Measures].[Status last updated more than 14 days ago]":[{“background_color”:"#B31238"}],"[Measures].[Average days in current status]":[{“background_color”:"#B3BAC5"}]}}},“calculated_members”:null}
} ],
“calculated_members”: [{“dimension”:“Measures”,“name”:“Issue status updated date”,“format_string”:“mmm dd yyyy”,“formula”:"[Issue].CurrentHierarchyMember.get(‘Status updated at’)",“annotations”:{“group”:“Issue properties”,“predefined”:true}},{“dimension”:“Measures”,“name”:“Issue closed date”,“format_string”:“mmm dd yyyy”,“formula”:"[Issue].CurrentHierarchyMember.get(‘Closed at’)",“annotations”:{“group”:“Issue properties”,“predefined”:true}},{“name”:“Status last updated less than 8 days ago”,“dimension”:“Measures”,“formula”:“NonZero(Count(\n Filter(\n Descendants([Issue].CurrentMember, [Issue].[Issue]),\n – for unresolved issues only\n isEmpty([Measures].[Issue closed date]) and\n – set interval\n DateDiffDays(\n ([Measures].[Issue status updated date],\n [Time].CurrentHierarchy.DefaultMember),\n Now()\n ) \u003e 0 and\n DateDiffDays(\n ([Measures].[Issue status updated date],\n [Time].CurrentHierarchy.DefaultMember),\n Now()\n ) \u003c= 7 and\n [Measures].[Issues created] \u003e0\n )\n))”,“format_string”:"#,##0",“annotations”:{}},{“name”:“Status last update 8-14 days ago”,“dimension”:“Measures”,“formula”:“NonZero(Count(\n Filter(\n Descendants([Issue].CurrentMember, [Issue].[Issue]),\n – for unresolved issues only\n isEmpty([Measures].[Issue closed date]) and\n – set interval\n DateDiffDays(\n ([Measures].[Issue status updated date],\n [Time].CurrentHierarchy.DefaultMember),\n Now()\n ) \u003e 7 and\n DateDiffDays(\n ([Measures].[Issue status updated date],\n [Time].CurrentHierarchy.DefaultMember),\n Now()\n ) \u003c= 14 and\n [Measures].[Issues created] \u003e0\n )\n))”,“format_string”:"#,##0",“annotations”:{}},{“name”:“Status last updated more than 14 days ago”,“dimension”:“Measures”,“formula”:“NonZero(Count(\n Filter(\n Descendants([Issue].CurrentMember, [Issue].[Issue]),\n – for unresolved issues only\n isEmpty([Measures].[Issue closed date]) and\n – set interval\n DateDiffDays(\n ([Measures].[Issue status updated date],\n [Time].CurrentHierarchy.DefaultMember),\n Now()\n ) \u003e 14 and\n [Measures].[Issues created] \u003e 0\n )\n))”,“format_string”:"#,##0",“annotations”:{}},{“name”:“Average days in current status”,“dimension”:“Measures”,“formula”:"-- days in current status from last transition for open issues\nAVG(\n Filter(\n Descendants([Issue].CurrentMember, [Issue].[Issue]),\n isEmpty([Measures].[Issue closed date])\n AND\n DateInPeriod(\n Now(),\n [Time].CurrentHierarchyMember)\n ),\n CASE WHEN\n ([Measures].[Issues due],\n [Time].CurrentHierarchy.DefaultMember) \u003e 0 \n THEN\n DateDiffDays([Measures].[Issue status updated date], Now()) \n END\n)",“format_string”:"#,##0.00",“annotations”:{}}]
}