Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Manual Row (Dimension) ordering in Freeform table

Avatar

Level 5

29-10-2015

It would be great if the option to manually select the ordering of the row dimensions were available, i.e. dragging and dropping where should go, just as we're able to do with the column dimensions - currently there is only the option of ascending or descending order. 

In terms of ordering of the columns it would also be useful to have the option of sorting the labels in ascending and descending order.

19 Comments

Avatar

Moderator

24-02-2017

Thanks for all this great feedback - we have manual row ordering on our backlog and are actively looking into a solution. I'd like to make sure I have the primary uses cases articulated so we can make sure we address them. Are they:

 

1) Ability to order metric rows manually, e.g. so you could show clicks, orders, then CVR in that order.

 

2) Ability to order numeric dimensions manually - for this one, we may not be able to let you click "sort in numerical order" because we store dimensions as text at this time (this hits another effort we are pursuing though), but would just the ability to drag & rearrange suffice in the meantime?

Avatar

Level 2

24-02-2017

@Jenlasser

Would #1 apply to segment rows too?

 

For #2, it would get rather tedious if we have many dimension values, but in general, manual reordering would be a decent stopgap for many of our problems.

 

The manual reordering would need to be able to be "locked" once we set the order, because it seems like often the items get reordered if the data gets re-ranked when it is refreshed.

 

I'm going to keep hinting until maybe it gets implemented: Can we just have a table builder in Ad Hoc? Please? Smiley Happy

Avatar

Level 3

17-05-2017

Exactly! This can be done in Ad Hoc and Report Builder (preserve order) - I assumed I just didn't know how to do it in Workspace. But this is a MUST! Example, I have a time parting hour variable and would like those to appear in the order they occur (12, 1, 2, 3, etc) and not sorted by which has more visits/activity.

 

Being able to set the order, preserve or lock the order, drag and drop- all that.

 

Please and thank you.

Avatar

Level 5

06-02-2019

Hadn't thought about #1, but would definitely use from time to time if available.

My primary use case for #2 is being able to order pages or segments in a funnel type of report.  I want to be able to order/lock in the order.

Avatar

Level 1

15-05-2020

Was option 2 solved?  It'd be great to manually order some dimensions so that they are always in the same order, no matter if visit sorting would be them in a different order.

Avatar

Moderator

18-05-2020

Option #2 can be achieve through manual reordering, but a "sort on numeric text" option is still not possible. We treat numeric IDs as text, not numbers, so it will take a bit more work to allow for that. 

 

Since manual ordering has been marked as Delivered, please open a new thread for numeric text sorting if that is an improvement you would still like to see. Thanks!