Expand my Community achievements bar.

Latest Community Ideas Review is Out: Discover What’s New and What to Expect!

Ability to Sort Report Groupings

Avatar

Community Advisor

3/3/23

In reports, we can sort columns, why can we not sort groupings? For example, I have a report with 3 groupings. One of the groupings is our business units. We have reasons why we want to see these groupings in alpha order. WF confirms that we cannot sort our groupings. Odd that this isn't possible even in text mode (if I'm wrong on this, someone chime in). Please upvote!

Madalyn_Destafney_0-1677862748295.png

 

9 Comments

Avatar

Community Advisor

3/3/23

Can say this is possible in Reporting Canvas, so it's absolutely coming. For now, I'd recommend adding the column in the view and sort (you can hide the column if you prefer)

Avatar

Community Advisor

3/3/23

Hi @Stephanie_Lou, long time no talk! ; )
I understand I can sort my results in the columns, but I am not able to sort the groupings themselves. See how your Team grouping is Design, then Content, Media, etc. - I want those to be alpha order. See how my business units groupings are not alpha order?

Madalyn_Destafney_0-1677865960483.png

It's minor but I want it possible for other reports they are using from this report.

Avatar

Level 7

3/3/23

I am with you! Adding a column to match the grouping works but it's a pain to add an unwanted column just so you can sort by that and then have to hide it if you don't want it to be visible. I would LOVE to be able to sort the list by the grouping without having to add the column!

Avatar

Level 2

3/3/23

@Madalyn_Destafney - I understand better now with this screenshot. I agree that sorting should be available in groupings. If I'm lucky, I'll inherit these with the hopes that sorting will be available down the pike. 

 

Avatar

Level 3

10/2/24

I agree although I would prefer to go one step further and sort by a custom order, not just alpha ascending or desecnding.

Avatar

Level 1

10/17/24

Hi @Madalyn_Destafney  I am new to workfront and trying to sort the column names which I created using grouping. But I am unable to do so. Is there any way to sort these like in ascending order or ,any way we can hide the row name "No days saved"

 

 

AnubhaBh_0-1729190116751.png

 

Avatar

Community Advisor

10/21/24

@AnubhaBh , this is what my Idea here is for - the ability to sort groupings. 
You can only hide your 'no days saved' groupings by applying a filter to your report that would remove those results.