How to sort field in groups/color

Question & Answer
,
1

Hello,

I have a vertical bar chart with three fields - one in x-axis, one in groups/color and one in small multiples.
I am not able to sort the field under groups by order of count. How do I do that?

2

Hi @ggpatil and welcome to the QuickSight community!
When you select the ellipses next to the value under group/color, do you not receive the ‘sort order’ option like below?:
image

Could you provide some screenshots of:

  • Your field well (the area that lists the fields you’re using for each section like shown above)
  • Your current visual
  • What you’d like your visual to look like after this change is made

Some additional information could assist in seeing where the problem lies.

Thank you!

3

Hi!
Thank you for your response!
I do see the option to sort. My field is a string data type. I want to sort by count of the field.
image

4

image
image478×822 25.5 KB

5

Hi @ggpatil,
Thanks for sharing! Could I see what the whole visual looks like? It may be a limitation due to the ‘small multiples’ addition but would be helpful to see the whole visual.

Thank you!

6

Hi @ggpatil,

couldn’t you use a calculated field with count(value) and filter it with off-visual field?

image

BG,
LKS

7

I don’t see a sort by option for groups/color. I used sort by for the other fields but it did not work.

8

image
image2512×1336 206 KB

9

Hi @ggpatil,
A couple notes on this:
Without a field in the ‘value’ section, it won’t be possible to sort by a different category, like ‘count’ in your instance. As ‘count’ isn’t being used as a measure anywhere, you can’t set it to be sorted.

Additionally, while you may be able to sort differently by adding a field to the value section, you may still run into a limitation as each ‘grouping’ will keep the categories in the same position across the graph. So when sorted, whatever is first in order on the first ‘group’, it will continue in that order across the visual in all other groupings.
I do not believe it’s possible to have each section of groupings across the x-axis to be sorted differently.

1 Like
10

Hi @ggpatil,
It’s been awhile since we last heard from you. Did you have any additional questions regarding your initial topic?

If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.

Thank you!

11

Hi @ggpatil,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information that may be needed.

Thank you!