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

[WORKSPACE] Sorting by dimensions

Avatar

Avatar
Springboard
Level 9
JarnoRossiCom
Level 9

Likes

404 likes

Total Posts

51 posts

Correct reply

0 solutions
Top badges earned
Springboard
Establish
Contributor
Shape 25
Shape 10
View profile

Avatar
Springboard
Level 9
JarnoRossiCom
Level 9

Likes

404 likes

Total Posts

51 posts

Correct reply

0 solutions
Top badges earned
Springboard
Establish
Contributor
Shape 25
Shape 10
View profile
JarnoRossiCom
Level 9

16-11-2017

Since the prehistory... In Adobe Analytics the possibility of sorting by dimension is something impossible.

Now we have workspace and I really dream to have it.

In freeform table we can sort by value we have in columns but not by value we have in rows. Please let's make it !! There are tons of reason why we need it. Try to think about a report where I'd like to have data sorted by Category of products, Zip codes, Order Id, Attributes of product...

18 Comments

Avatar

Avatar
Give Back 25
Level 5
Balaji_V
Level 5

Likes

76 likes

Total Posts

70 posts

Correct reply

10 solutions
Top badges earned
Give Back 25
Give Back 10
Give Back 5
Establish
Contributor
View profile

Avatar
Give Back 25
Level 5
Balaji_V
Level 5

Likes

76 likes

Total Posts

70 posts

Correct reply

10 solutions
Top badges earned
Give Back 25
Give Back 10
Give Back 5
Establish
Contributor
View profile
Balaji_V
Level 5

06-08-2019

Sorting by alphabetic order at easy

Avatar

Avatar
Contributor
Level 2
fwachsmuth
Level 2

Likes

8 likes

Total Posts

9 posts

Correct reply

0 solutions
Top badges earned
Contributor
Shape 1
Boost 5
Boost 3
Boost 1
View profile

Avatar
Contributor
Level 2
fwachsmuth
Level 2

Likes

8 likes

Total Posts

9 posts

Correct reply

0 solutions
Top badges earned
Contributor
Shape 1
Boost 5
Boost 3
Boost 1
View profile
fwachsmuth
Level 2

18-10-2019

This. So much. When can we haz it?

Avatar

Avatar
Contributor
Level 2
fwachsmuth
Level 2

Likes

8 likes

Total Posts

9 posts

Correct reply

0 solutions
Top badges earned
Contributor
Shape 1
Boost 5
Boost 3
Boost 1
View profile

Avatar
Contributor
Level 2
fwachsmuth
Level 2

Likes

8 likes

Total Posts

9 posts

Correct reply

0 solutions
Top badges earned
Contributor
Shape 1
Boost 5
Boost 3
Boost 1
View profile
fwachsmuth
Level 2

27-07-2020

I found a workaround for this which works well if the permuttaion count of your dimension is <= 400:
- Show all dimension values in a freeform table
- Select all of them
- Right-click and "show only selected columns"

 

-> Voilà, you can now sort by them. 

 

Dangerous though if new metrics would come in, since they wouldn't be shown. 

Avatar

Avatar
Give Back 5
Employee
trevorpaulsen
Employee

Likes

0 likes

Total Posts

43 posts

Correct reply

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

Avatar
Give Back 5
Employee
trevorpaulsen
Employee

Likes

0 likes

Total Posts

43 posts

Correct reply

0 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Ignite 1
View profile
trevorpaulsen
Employee

26-01-2021

The good news is that we actually now support this in Customer Journey Analytics for all dimensions. The bad news is that for technical reasons this isn't possible in traditional Analytics. For more information on CJA you can check out:  CJA Spark Page

Avatar

Avatar
Level 1
animateddolphin
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile

Avatar
Level 1
animateddolphin
Level 1

Likes

0 likes

Total Posts

1 post

Correct reply

0 solutions
View profile
animateddolphin
Level 1

24-02-2021

Yes please add! Thank you

Avatar

Avatar
Give Back 3
Level 1
acookie4rachel
Level 1

Likes

0 likes

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Give Back 3
Give Back
Applaud 5
View profile

Avatar
Give Back 3
Level 1
acookie4rachel
Level 1

Likes

0 likes

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Give Back 3
Give Back
Applaud 5
View profile
acookie4rachel
Level 1

25-08-2021

Any good news on this? I need to sort 'Industries' dimension alphabetically because client is used to viewing Industries by alphabetical order. The client finds it messy and hard to visualise when the industries are sorted by a corresponding metric.

Avatar

Avatar
Contributor
Level 2
fwachsmuth
Level 2

Likes

8 likes

Total Posts

9 posts

Correct reply

0 solutions
Top badges earned
Contributor
Shape 1
Boost 5
Boost 3
Boost 1
View profile

Avatar
Contributor
Level 2
fwachsmuth
Level 2

Likes

8 likes

Total Posts

9 posts

Correct reply

0 solutions
Top badges earned
Contributor
Shape 1
Boost 5
Boost 3
Boost 1
View profile
fwachsmuth
Level 2

25-08-2021

It's doable if you have less than 400 values in the dimension. The trick is to mark them all, right click and chose "show only selected rows". Once done, they are sortable. 

Caveat: new values won't appear in such a table until you change the selection. 

Avatar

Avatar
Give Back 3
Level 1
acookie4rachel
Level 1

Likes

0 likes

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Give Back 3
Give Back
Applaud 5
View profile

Avatar
Give Back 3
Level 1
acookie4rachel
Level 1

Likes

0 likes

Total Posts

5 posts

Correct reply

0 solutions
Top badges earned
Give Back 3
Give Back
Applaud 5
View profile
acookie4rachel
Level 1

25-08-2021

@fwachsmuth  Thanks for the workaround! It's odd that we can only sort the selected dimension items.. this workaround is good for now for reporting purpose.