Sorting report in descending Order

geohan · April 30, 2018, 11:24pm

I am new to eazyBI and I would like to know how we can sort an eazyBI report in DESC order.

Requirement is: I have a report which should the defects reopened by each team member and sort it in descending order. As of now, my report sort order is jumbled.

Could you pls help

arama_mihai · May 2, 2018, 8:01am

Hi,

When you hover over a column, you some arrows will appear. You can click on those to perform sorting.

geohan · May 7, 2018, 2:39pm

martins.vanags · May 9, 2018, 1:29pm

Hi,

This kind of sorting would require a calculated member in “Issue Type” dimension to aggregate three issue types into a new member.
Try this code:

 Aggregate({
 [Issue Type].[Bug],
 [Issue Type].[Enhancement],
 [Issue Type].[Sub-bug]
 })

Then you could select this new member from Issue Type dimension and collapse it.

Next, you sort your report by Transition Status member.
Later you could expand the issue type member to issue type level and finally remove the header column.

See attached gif.

Best regards,
Martins / eazyBI support