Manual Row (Dimension) ordering in Freeform table

Avatar

Avatar

dan82214677

Avatar

dan82214677

dan82214677

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 (19 New)
19 Comments

Avatar

Avatar

jen_lasser

Moderator

Avatar

jen_lasser

Moderator

jen_lasser
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

Avatar

salernoam29

Avatar

salernoam29

salernoam29

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

Avatar

samsnarr

Avatar

samsnarr

samsnarr

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

Avatar

mikethompson

Avatar

mikethompson

mikethompson

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

Avatar

Gigazelle

Employee

Total Posts

1.9K

Likes

459

Correct Answer

734

Avatar

Gigazelle

Employee

Total Posts

1.9K

Likes

459

Correct Answer

734
Gigazelle
Employee

06-02-2019

Avatar

Avatar

jen_lasser

Moderator

Avatar

jen_lasser

Moderator

jen_lasser
Moderator

22-01-2020

Delivered on Jan 21, 2020 as part of Freeform table builder - https://www.youtube.com/watch?v=94WZwQRYdS8

Avatar

Avatar

Gaurang

Community Manager

Avatar

Gaurang

Community Manager

Gaurang
Community Manager

22-01-2020

 
Status changed to: Delivered

Avatar

Avatar

dbachota

Avatar

dbachota

dbachota

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

Avatar

jen_lasser

Moderator

Avatar

jen_lasser

Moderator

jen_lasser
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!