Hi, I need to get all issues by the Updated (not creation date) and use the time as filter.
Regards.
{
"cube_name": "Issues",
"cube_reports": [ {
"name": "Regression Test Cases",
"folder_name": "Sportbooks Testing Metric",
"result_view": "line_chart",
"definition": {"columns":{"dimensions":[{"name":"Measures","selected_set":["[Measures].[Issues created]"],"members":[]}]},"rows":{"dimensions":[{"name":"Time","selected_set":["[Time].[2022].[Q3 2022].[Aug 2022]","[Time].[2022].[Q3 2022].[Sep 2022]","[Time].[2022].[Q4 2022].[Oct 2022]","[Time].[2022].[Q4 2022].[Nov 2022]","[Time].[2022].[Q4 2022].[Dec 2022]","[Time].[2023].[Q2 2023].[May 2023]","[Time].[2023].[Q2 2023].[Jun 2023]","[Time].[2023].[Q3 2023].[Jul 2023]","[Time].[2023].[Q3 2023].[Aug 2023]","[Time].[2023].[Q3 2023].[Sep 2023]","[Time].[2023].[Q4 2023].[Oct 2023]","[Time].[2023].[Q4 2023].[Dec 2023]"],"members":[],"bookmarked_members":[]}]},"pages":{"dimensions":[{"name":"Regression","selected_set":["[Regression].[All Regressions]"],"members":[{"depth":0,"name":"All Regressions","full_name":"[Regression].[All Regressions]","drillable":true,"type":"all","expanded":true,"drilled_into":false},{"depth":1,"name":"Yes","full_name":"[Regression].[Yes]","parent_full_name":"[Regression].[All Regressions]"}],"bookmarked_members":[],"current_page_members":["[Regression].[Yes]"]},{"name":"Reporter","selected_set":["[Reporter].[Sportsbook-QA Members]"],"members":[{"depth":0,"name":"Sportsbook-QA Members","full_name":"[Reporter].[Sportsbook-QA Members]","calculated":true,"drillable":true,"dimension":"Reporter","expanded":true,"drilled_into":false}],"bookmarked_members":[],"current_page_members":["[Reporter].[Sportsbook-QA Members]"]},{"name":"Issue Type","selected_set":["[Issue Type].[Test]"],"members":[{"depth":1,"name":"Test","full_name":"[Issue Type].[Test]"}],"bookmarked_members":[],"current_page_members":["[Issue Type].[Test]"]},{"name":"Time","duplicate":true,"selected_set":["[Time].[All Times]"],"members":[{"depth":0,"name":"All Times","full_name":"[Time].[All Times]","drillable":true,"type":"all","expanded":true,"drilled_into":false},{"depth":1,"name":"2022","full_name":"[Time].[2022]","drillable":true,"expanded":true,"drilled_into":false,"parent_full_name":"[Time].[All Times]"},{"depth":2,"name":"Q3 2022","full_name":"[Time].[2022].[Q3 2022]","drillable":true,"expanded":true,"drilled_into":false,"parent_full_name":"[Time].[2022]"},{"depth":3,"name":"Aug 2022","full_name":"[Time].[2022].[Q3 2022].[Aug 2022]","drillable":true,"parent_full_name":"[Time].[2022].[Q3 2022]"},{"depth":3,"name":"Sep 2022","full_name":"[Time].[2022].[Q3 2022].[Sep 2022]","drillable":true,"parent_full_name":"[Time].[2022].[Q3 2022]"},{"depth":2,"name":"Q4 2022","full_name":"[Time].[2022].[Q4 2022]","drillable":true,"expanded":true,"drilled_into":false,"parent_full_name":"[Time].[2022]"},{"depth":3,"name":"Oct 2022","full_name":"[Time].[2022].[Q4 2022].[Oct 2022]","drillable":true,"parent_full_name":"[Time].[2022].[Q4 2022]"},{"depth":3,"name":"Nov 2022","full_name":"[Time].[2022].[Q4 2022].[Nov 2022]","drillable":true,"parent_full_name":"[Time].[2022].[Q4 2022]"},{"depth":3,"name":"Dec 2022","full_name":"[Time].[2022].[Q4 2022].[Dec 2022]","drillable":true,"parent_full_name":"[Time].[2022].[Q4 2022]"},{"depth":1,"name":"2023","full_name":"[Time].[2023]","drillable":true,"expanded":true,"drilled_into":false,"parent_full_name":"[Time].[All Times]"},{"depth":2,"name":"Q2 2023","full_name":"[Time].[2023].[Q2 2023]","drillable":true,"expanded":true,"drilled_into":false,"parent_full_name":"[Time].[2023]"},{"depth":3,"name":"May 2023","full_name":"[Time].[2023].[Q2 2023].[May 2023]","drillable":true,"parent_full_name":"[Time].[2023].[Q2 2023]"},{"depth":3,"name":"Jun 2023","full_name":"[Time].[2023].[Q2 2023].[Jun 2023]","drillable":true,"parent_full_name":"[Time].[2023].[Q2 2023]"},{"depth":2,"name":"Q3 2023","full_name":"[Time].[2023].[Q3 2023]","drillable":true,"expanded":true,"drilled_into":false,"parent_full_name":"[Time].[2023]"},{"depth":3,"name":"Jul 2023","full_name":"[Time].[2023].[Q3 2023].[Jul 2023]","drillable":true,"parent_full_name":"[Time].[2023].[Q3 2023]"},{"depth":3,"name":"Aug 2023","full_name":"[Time].[2023].[Q3 2023].[Aug 2023]","drillable":true,"parent_full_name":"[Time].[2023].[Q3 2023]"},{"depth":3,"name":"Sep 2023","full_name":"[Time].[2023].[Q3 2023].[Sep 2023]","drillable":true,"parent_full_name":"[Time].[2023].[Q3 2023]"},{"depth":2,"name":"Q4 2023","full_name":"[Time].[2023].[Q4 2023]","drillable":true,"expanded":true,"drilled_into":false,"parent_full_name":"[Time].[2023]"},{"depth":3,"name":"Oct 2023","full_name":"[Time].[2023].[Q4 2023].[Oct 2023]","drillable":true,"parent_full_name":"[Time].[2023].[Q4 2023]"},{"depth":3,"name":"Dec 2023","full_name":"[Time].[2023].[Q4 2023].[Dec 2023]","drillable":true,"parent_full_name":"[Time].[2023].[Q4 2023]"}],"bookmarked_members":[],"current_page_members":["[Time].[2022].[Q3 2022].[Aug 2022]","[Time].[2022].[Q3 2022].[Sep 2022]","[Time].[2022].[Q4 2022].[Oct 2022]","[Time].[2022].[Q4 2022].[Nov 2022]","[Time].[2022].[Q4 2022].[Dec 2022]","[Time].[2023].[Q2 2023].[May 2023]","[Time].[2023].[Q2 2023].[Jun 2023]","[Time].[2023].[Q3 2023].[Jul 2023]","[Time].[2023].[Q3 2023].[Aug 2023]","[Time].[2023].[Q3 2023].[Sep 2023]","[Time].[2023].[Q4 2023].[Oct 2023]","[Time].[2023].[Q4 2023].[Dec 2023]"]}]},"options":{},"view":{"current":"line_chart","maximized":false,"line_chart":{"area":false,"swap_axes":false,"data_labels":true,"series_options":{}},"table":{}},"calculated_members":[]}
} ],
"calculated_members": [{"name":"Sportsbook-QA Members","dimension":"Reporter","formula":"Aggregate({\n [Reporter].[X],\n })","format_string":""}]
}