Sorting all fix-version

I’m trying to create a report with alphabetically sorted list of all fix-version thru calculated field but seems not to be working out.

What am I doing wrong?

Tx!

Aggregate(
Order(
Filter([Fix Version].[Version].Members,
[Fix Version].CurrentMember.Name <> “(no version)”
),
[Fix Version].CurrentMember.Name,
DESC)
)

Your formula orders versions taking into account a hierarchy - particular project and status.

DESC - sorts members descending taking into account a members hierarchy. You would like to use BDESC to ignore any hierarchy and get an ordered list of all versions of any project in any status.

Aggregate(
Order(
Filter([Fix Version].[Version].Members,
[Fix Version].CurrentMember.Name <> "(no version)"
),
[Fix Version].CurrentMember.Name,
BDESC)
)

Daina / support@eazybi.com

1 Like

How you can get the number of issues closed on each fix version?¡

In the report example define above, where Fix Version dimension is used on Rows, you can add any measure and it will represent values for each version. You can use measure Issues closed to see closed issues of any Fix Version. Issues closed measure works on particular statuses set in import options.

If you would like to see a status on Fix Version at the fix version resolution date, you can check our report examples in our demo account:

Here is an excerption from measure Resolved issues in version at release date from this Version release report, counting closed issues (instead of resolved issues) on Fix Version resolution date:

Cache(    
	Sum(PreviousPeriods([Time].CurrentHierarchy.Levels("Day").DateMember(
        [Fix Version].CurrentMember.get('Release date')).NextMember),
        [Measures].[Issues closed]
    )
)

Daina / support@eazybi.com