Showing most recent measure

I have a custom cube of data that has pipeline names with some test code coverage data. Each day, another row for each pipeline gets added to the cube with the latest code coverage data. What I would like to display is the latest code coverage (by date) for each pipeline. Currently, though, my report is summing up all the code coverage data per pipeline, which isn’t what I want. Below is my report definition:

  "cube_name": "Unit Test Coverage",
  "cube_reports": [ {
     "name": "Unit Test Coverage Per Repo",
     "folder_name": "2021 Engineering OKRs",
     "result_view": "table",
     "definition": {"columns":{"dimensions":[{"name":"Measures","selected_set":["[Measures].[Coverable lines]","[Measures].[Covered lines]","[Measures].[Coverage %]"],"members":null}]},"rows":{"dimensions":[{"name":"Pipeline name","selected_set":["[Pipeline name].[All Pipeline names]"],"members":[{"depth":0,"name":"All Pipeline names","full_name":"[Pipeline name].[All Pipeline names]","drillable":true,"type":"all","expanded":true,"drilled_into":false}],"bookmarked_members":null}]},"pages":{"dimensions":[{"name":"Time","selected_set":["[Time].[All Times]"],"members":[{"depth":0,"name":"All Times","full_name":"[Time].[All Times]","drillable":true,"type":"all"}],"bookmarked_members":null,"current_page_members":["[Time].[All Times]"]}]},"options":{},"view":{"current":"table","maximized":false,"table":{}},"calculated_members":null}
  } ],
  "calculated_members": [{"name":"Coverage %","dimension":"Measures","formula":"CASE WHEN\n  [Measures].[Coverable lines] = 0\nTHEN\n  0\nELSE\n  [Measures].[Covered lines] / [Measures].[Coverable lines]\nEND","format_string":"#0.00%"}]


Hi @dave!

I would imagine that you map the data by pipeline and date. In such a case, when you select the Time in pages, you would see the coverage per Pipeline and Time period.

If this is not the case, could you please share more details of the data mapping? (Screenshots would be helpful, you can send them over to with a link to this thread)

Lauma /