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

Learn More

View all

Sign in to view all badges

Manual Row (Dimension) ordering in Freeform table

Avatar

Avatar
Boost 50
Level 5
dan82214677
Level 5

Likes

111 likes

Total Posts

34 posts

Correct Reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 100
View profile

Avatar
Boost 50
Level 5
dan82214677
Level 5

Likes

111 likes

Total Posts

34 posts

Correct Reply

0 solutions
Top badges earned
Boost 50
Boost 5
Boost 3
Boost 25
Boost 100
View profile
dan82214677
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

Avatar
Ignite 3
Moderator
jen_lasser
Moderator

Likes

113 likes

Total Posts

313 posts

Correct Reply

8 solutions
Top badges earned
Ignite 3
Ignite 1
Give Back 5
Give Back 3
Give Back 10
View profile

Avatar
Ignite 3
Moderator
jen_lasser
Moderator

Likes

113 likes

Total Posts

313 posts

Correct Reply

8 solutions
Top badges earned
Ignite 3
Ignite 1
Give Back 5
Give Back 3
Give Back 10
View profile
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
Boost 5
Level 2
salernoam29
Level 2

Likes

16 likes

Total Posts

34 posts

Correct Reply

1 solution
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Applaud 5
View profile

Avatar
Boost 5
Level 2
salernoam29
Level 2

Likes

16 likes

Total Posts

34 posts

Correct Reply

1 solution
Top badges earned
Boost 5
Boost 3
Boost 10
Boost 1
Applaud 5
View profile
salernoam29
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

Avatar
Boost 5
Level 3
samsnarr
Level 3

Likes

32 likes

Total Posts

8 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile

Avatar
Boost 5
Level 3
samsnarr
Level 3

Likes

32 likes

Total Posts

8 posts

Correct Reply

0 solutions
Top badges earned
Boost 5
Boost 3
Boost 25
Boost 10
Boost 1
View profile
samsnarr
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

Avatar
Validate 1
Level 4
mikethompson
Level 4

Likes

62 likes

Total Posts

102 posts

Correct Reply

14 solutions
Top badges earned
Validate 1
Shape 1
Shape 10
Boost 50
Boost 5
View profile

Avatar
Validate 1
Level 4
mikethompson
Level 4

Likes

62 likes

Total Posts

102 posts

Correct Reply

14 solutions
Top badges earned
Validate 1
Shape 1
Shape 10
Boost 50
Boost 5
View profile
mikethompson
Level 4

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
Coach
Employee
Gigazelle
Employee

Likes

468 likes

Total Posts

1,947 posts

Correct Reply

739 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile

Avatar
Coach
Employee
Gigazelle
Employee

Likes

468 likes

Total Posts

1,947 posts

Correct Reply

739 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile
Gigazelle
Employee

06-02-2019

Avatar

Avatar
Ignite 3
Moderator
jen_lasser
Moderator

Likes

113 likes

Total Posts

313 posts

Correct Reply

8 solutions
Top badges earned
Ignite 3
Ignite 1
Give Back 5
Give Back 3
Give Back 10
View profile

Avatar
Ignite 3
Moderator
jen_lasser
Moderator

Likes

113 likes

Total Posts

313 posts

Correct Reply

8 solutions
Top badges earned
Ignite 3
Ignite 1
Give Back 5
Give Back 3
Give Back 10
View profile
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
Springboard
Level 9
Gaurang
Level 9

Likes

143 likes

Total Posts

435 posts

Correct Reply

45 solutions
Top badges earned
Springboard
Validate 100
Validate 50
Validate 25
Validate 10
View profile

Avatar
Springboard
Level 9
Gaurang
Level 9

Likes

143 likes

Total Posts

435 posts

Correct Reply

45 solutions
Top badges earned
Springboard
Validate 100
Validate 50
Validate 25
Validate 10
View profile
Gaurang
Level 9

22-01-2020

 
Status changed to: Delivered

Avatar

Avatar
Boost 1
Level 1
dbachota
Level 1

Like

1 like

Total Posts

8 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile

Avatar
Boost 1
Level 1
dbachota
Level 1

Like

1 like

Total Posts

8 posts

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile
dbachota
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

Avatar
Ignite 3
Moderator
jen_lasser
Moderator

Likes

113 likes

Total Posts

313 posts

Correct Reply

8 solutions
Top badges earned
Ignite 3
Ignite 1
Give Back 5
Give Back 3
Give Back 10
View profile

Avatar
Ignite 3
Moderator
jen_lasser
Moderator

Likes

113 likes

Total Posts

313 posts

Correct Reply

8 solutions
Top badges earned
Ignite 3
Ignite 1
Give Back 5
Give Back 3
Give Back 10
View profile
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!