Nested Sort - per multiple columns

[ran.lavi]

Currently EazyBI tables allows sorting only per one column.
Sometimes it is required to do a nested sorting: Sort per one column, and then a secondary sort per another column.
We would appreciate adding this to your backlog.

[daina.tupule]

Hi Ran

We added the request to our development backlog.

[frajus]

Hi guys, we also are interested in this feature. Is there a chance that it will be implemented or is there a workaround to achieve this? Thanks.

[Racquel_Burton]

We are also interested. Any plans to add this?

[Melissa_Martin]

Any update on this? This seems like a really valuable feature.

[HugoVarandas]

Any workaround to make a nested sort?

[zane.baranovska]

This feature is still on our backlog.
The workaround is a calculated measure that could be used for ordering. Here are few examples:

How To sort by 2 Columns, One ASC and the other DESC

Hi, Try this formula when creating a new calculated measure: Cast([Sprint].CurrentMember.Name as string)||" - "|| Cast( Rank( [Sprint].CurrentMember, Order( [Sprint].[Sprint].Members, [Measures].[Sprint end date], BASC ) )as string) Then sort your report by this new calculated measure in descending order. Finally, you could click on the column and remove it. The sorting must remain in the report Martins / eazyBI team [sorted by sprint name and end date]

Order by First Row

Hi everybody! I have table with two dimensions: “Impacted Features” and Time. The time dimensions is also a page, in order for it to be selectable. The problem is: I want to order the table by “Impacted Feature”. When I try to sort itthe impacted features get jumbled as only Time is sorted: [image] (see how the “Impacted Feature” “CM: Search and filters” is repeated by quarter) Ss I want to keep the agregation by “Impacted Feature”, like this: [image] while ordering the sum of it’s valu…

Best,
Zane / support@eazyBI.com

[morjo02]

Hi eazyBI support team,
Please provide an update on this feature enhancement request. Any ETA for a future release?
John

[zane.baranovska]

There is nothing new regarding this feature to order by multiple columns; it is still on our backlog but not on the roadmap.

Zane / Support@eazyBI.com

[Kickbackjack]

@zane.baranovska
Hi any update on this feature?

[zane.baranovska]

This feature is not on our roadmap yet. However, your comment on this Community post counts as a vote to make the feature more popular.

Meanwhile, use dimensions to group data by similar fields or calcauted measures to concatenate values and then use that concatinated valu fro sorting data.

How To sort by 2 Columns, One ASC and the other DESC

Hi, Try this formula when creating a new calculated measure: Cast([Sprint].CurrentMember.Name as string)||" - "|| Cast( Rank( [Sprint].CurrentMember, Order( [Sprint].[Sprint].Members, [Measures].[Sprint end date], BASC ) )as string) Then sort your report by this new calculated measure in descending order. Finally, you could click on the column and remove it. The sorting must remain in the report Martins / eazyBI team [sorted by sprint name and end date]

Order by First Row

Hi, As you need to keep the aggregation of the Impacted feature, I assume that ordering would be needed within the aggregated rows of the “Impacted feature”. For that, you can create a custom measure for ordering. The measure would concatenate the name of the first dimension and the amount of the measure. Then you can apply ordering on that measure and remove it from the report for keeping the report clean and preserving the order. In your case, the custom measure for ordering would be the fol…

Best,
Zane / support@eazyBI.com