Expand my Community achievements bar.

Manual Row (Dimension) ordering in Freeform table

Avatar

Level 5

10/29/15

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.

21 Comments

Avatar

Employee Advisor

2/24/17

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

2/24/17

@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

5/17/17

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

2/6/19

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

5/15/20

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

Employee Advisor

5/18/20

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!

Avatar

Level 1

7/22/22

@Jen - I already had a table built and now want to reorder. The drag-and-drop option as shown in the video seems to only work for me when creating a new table from scratch.  How to reorder the rows in an existing table?