Order by sprint in story balance report

Questions & Answers
1

I am using one of the sample reports for my projects.
Its story points balance by sprints.

https://eazybi.com/accounts/1632/cubes/Issues/reports/83364-sample-story-points-balance-by-sprints

Right now the sprints on X-axis are in completely jumbled order.

As soon as I use one of the sort by functions, the data completely disappears. Can you please help me in achieving this?

Below is the function that I am using:

Aggregate({
Order(
[Sprint].[Sprint].Members,
[Sprint].CurrentMember.get(‘Start date’), BASC
)
})

Thank you
Ravi Talasila

2

Hi Ravi,

Your approach and the calculation are correct, the only problem is: the report is filtered by sprint properties “Is Closed” = Yes and “Sprint Story points committed” > 0 . Neither of those values are available for the top row of the calculated member: when you add this member (collapsed) in rows, it is instantly filtered out as not matching.
You may want to remove those filters first, then add the member, expand it and only then set filters back.

Probably, a simpler option than creating a new member would be adding, in columns, a measure “Sprint Start date” and then order by this column; then remove the column, order conditions.

Ilze, support@eazybi.com