Ability to Sort Report Groupings | Community
Skip to main content
Madalyn_Destafney
Community Advisor
Community Advisor
March 3, 2023
New

Ability to Sort Report Groupings

  • March 3, 2023
  • 9 replies
  • 1854 views

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!

 

9 replies

MoniqueEvans
Community Advisor
Community Advisor
March 3, 2023

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)

Stephanie_Lou
Level 2
March 3, 2023

Hi @madalyn_destafney! On my reports with multiple groupings, I sort by alpha order in the Columns (View) section. Have you tried this?

 

Madalyn_Destafney
Community Advisor
Community Advisor
March 3, 2023

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?

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

If this helped you, please mark correct to help others : )
RhondaGayleTX
Level 5
March 3, 2023

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!

Stephanie_Lou
Level 2
March 3, 2023

@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. 😊

 

JamesHill_ATL
Level 3
March 9, 2023

agree, let's do this!

Level 3
October 2, 2024

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

October 17, 2024

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"

 

 

 

Madalyn_Destafney
Community Advisor
Community Advisor
October 21, 2024

@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.

If this helped you, please mark correct to help others : )