Manually order dimension items in a freeform table?

Avatar

Avatar
Validate 10
Level 3
mooreevan
Level 3

Likes

14 likes

Total Posts

48 posts

Correct reply

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

Avatar
Validate 10
Level 3
mooreevan
Level 3

Likes

14 likes

Total Posts

48 posts

Correct reply

1 solution
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
mooreevan
Level 3

07-03-2019

Hello,

I have 3rd party data coming into Analytics through a connector, into a dimension. I'm working on visualizing that information in a Workspace project.

I'd like to force an order to the dimension items. Instead of ordering the dimension items by the metric, I'd like to force my own order. Is this possible?

In the screenshot below, I'd like to order the revenue range groups by ascending/descending order, which I can do manually if available.

Thanks!

1707335_pastedImage_0.png

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Coach
MVP
ursboller
MVP

Likes

525 likes

Total Posts

1,020 posts

Correct reply

257 solutions
Top badges earned
Coach
Contributor
Bedrock
Seeker
Springboard
View profile

Avatar
Coach
MVP
ursboller
MVP

Likes

525 likes

Total Posts

1,020 posts

Correct reply

257 solutions
Top badges earned
Coach
Contributor
Bedrock
Seeker
Springboard
View profile
ursboller
MVP

11-03-2019

a "manual sorting" is not possible right now - upvote Custom Sorting

I you have just a few items (or too much time for more dimensions) you could add a "fake metric column" used for sorting: create a calculated metric with a bunch of "if ... then ... else" formulas and output the desired position. then prder by this row and make is as small as possible (just before it dissapears

the formula would look something like

{

if (dimension1) "occurencies" greater than 1

then 1 (as static number)

else {

  if (dimension2) "occurencies" greater than 1

  then 2

  else {

     ...

  }

}

while (dimension1-X) are just "dimension filters" (drop dimension in metric an select desired value)

if you add this metric to your table it will output a "1" for (dimension1), a "2" for (dimension2) ... and allows you to sort as desired

I know, not the best .... but you asked about a solution

Answers (7)

Answers (7)

Avatar

Avatar
Coach
MVP
ursboller
MVP

Likes

525 likes

Total Posts

1,020 posts

Correct reply

257 solutions
Top badges earned
Coach
Contributor
Bedrock
Seeker
Springboard
View profile

Avatar
Coach
MVP
ursboller
MVP

Likes

525 likes

Total Posts

1,020 posts

Correct reply

257 solutions
Top badges earned
Coach
Contributor
Bedrock
Seeker
Springboard
View profile
ursboller
MVP

13-03-2019

you mean, if you have manuel sorting on the dimension items the new metric "overrides" the sorting? might just be the "default" ... sorry I couldn't help...

Avatar

Avatar
Validate 10
Level 3
mooreevan
Level 3

Likes

14 likes

Total Posts

48 posts

Correct reply

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

Avatar
Validate 10
Level 3
mooreevan
Level 3

Likes

14 likes

Total Posts

48 posts

Correct reply

1 solution
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
mooreevan
Level 3

13-03-2019

Huh. If you add a new free form table and add dimension items one at a time, they seem appear at the bottom of the list each time. Could obviously use that for manual ordering. However, once you add a metric other than Occurrences, the manual order gets reordered by the metric. So close but so far.

Avatar

Avatar
Validate 10
Level 3
mooreevan
Level 3

Likes

14 likes

Total Posts

48 posts

Correct reply

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

Avatar
Validate 10
Level 3
mooreevan
Level 3

Likes

14 likes

Total Posts

48 posts

Correct reply

1 solution
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
mooreevan
Level 3

11-03-2019

This sounds like quality, remedial Friday afternoon work. Thanks for the idea and the link to the Idea.

Avatar

Avatar
Validate 10
Level 3
mooreevan
Level 3

Likes

14 likes

Total Posts

48 posts

Correct reply

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

Avatar
Validate 10
Level 3
mooreevan
Level 3

Likes

14 likes

Total Posts

48 posts

Correct reply

1 solution
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
mooreevan
Level 3

11-03-2019

Yes, I do! I didn't know that was there, that's helpful for other analyses, thanks.

However, that just sorts alphabetically, which isn't what I'm after in this example. This example would still require a full manual sorting option, which could be as simple as the order I drop dimension items into the table.

Avatar

Avatar
Coach
MVP
ursboller
MVP

Likes

525 likes

Total Posts

1,020 posts

Correct reply

257 solutions
Top badges earned
Coach
Contributor
Bedrock
Seeker
Springboard
View profile

Avatar
Coach
MVP
ursboller
MVP

Likes

525 likes

Total Posts

1,020 posts

Correct reply

257 solutions
Top badges earned
Coach
Contributor
Bedrock
Seeker
Springboard
View profile
ursboller
MVP

08-03-2019

when you drop just single items, do you have an option on the header row (of the dimension) to manually sort? in your screenshot next to "Revenue Range" there should appear a sort arrow after the first few items (maybe only appears when you hover over the header field)

Avatar

Avatar
Validate 10
Level 3
mooreevan
Level 3

Likes

14 likes

Total Posts

48 posts

Correct reply

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

Avatar
Validate 10
Level 3
mooreevan
Level 3

Likes

14 likes

Total Posts

48 posts

Correct reply

1 solution
Top badges earned
Validate 10
Validate 1
Boost 5
Boost 3
Boost 10
View profile
mooreevan
Level 3

08-03-2019

That would be useful if I could manually drop them in, but when I try that, the metric sorting still takes precedence.

I tried dropping in dimension items one at a time; selecting in order, then dropping in all together; and doing that all with and without metrics present. I can't get the order to hold any way I do it.

Let me know if I'm doing something wrong, details if you can.

Thanks!

Avatar

Avatar
Contributor
MVP
AlexisCazes
MVP

Likes

187 likes

Total Posts

424 posts

Correct reply

198 solutions
Top badges earned
Contributor
Shape 1
Give Back 10
Give Back 5
Give Back 3
View profile

Avatar
Contributor
MVP
AlexisCazes
MVP

Likes

187 likes

Total Posts

424 posts

Correct reply

198 solutions
Top badges earned
Contributor
Shape 1
Give Back 10
Give Back 5
Give Back 3
View profile
AlexisCazes
MVP

08-03-2019

I believe the only solution would be to drop the dimensions one by one. For the moment it is not possible to oder alphabetically or freeze the order of the dimensions.

Gigazelle​ can you please confirm ?