Custom sort of groups on Horizontal Stacked 100% Bar Chart

Hopefully quite a simple one. I have a Horizontal Stacked 100% Bar Chart. I have:

Y-axis = A drill down dimension of 2 layers
Measure = None (so just shows a count)
Group/Colour = A field called “Status”

All the data is correct. I notice that the values are sorted so they will always show up in Alphabetical order for each Status. So if I have statuses of WAITING, ON_TIME, LATE, MISSED, they will show up in order LATE>MISSED>ON_TIME>WAITING. Or opposite if I choose descending sort.

However I want to order it with my own custom sort order. Is there any way to achieve this without renaming those statuses (as they’re fine as they are). I can’t seem to find any option to sort by another field as I could have solved this with calculated field otherwise.

Any help would be appreciated, thanks!

Hi @beliash

The field on the Y axis may be sorted using an Off-field visual which could be a calculated field where you can specify a custom order. The group-by field does not have this option.

So, you may need to rename your status. You can create a calculated field, have the text for the status the same but prefix with a number in the order you want the statuses to appear.

Regards,
Giri

Thanks Giridhar. Unfortunately it’s the group-by I’d like to order! Quicksight team, can this be raised as a feature request please?

Agree the workaround is appending numbers to the start of values, but it feels quite amateur, imho we shouldn’t have to update data in a visual just to change how it is displayed.

Cheers for confirming though Giridhar :slight_smile:

Many thanks,
Ash

Hi @beliash

While I am not quite sure QuickSight has High Charts now. When the standard visuals don’t work for you you may create your customized visuals using High Charts.

You may check the documentation and examples in Demo Central

Hi @beliash,
It’s been awhile since we last heard from you, did you have any additional questions regarding your post or were you able to find a work around?

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

Thank you!

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

Thank you!