Vertical bar chart - Sort X Axis and Small Multiples by off-visual fields

lbl · December 26, 2024, 2:05am

Product Category and Country have values OTHERS which should be displayed as the last item.
I have calculated field productCatSort and countrySort as interger to represent the sorting sequence. However, I can only specify 1 off-visual field for sorting.

Any workaround?

Thanks!

apjvinod · December 26, 2024, 5:00am

Hi @lbl

Currently QuickSight supports sorting based on only one off-visual field. Would suggest to do the off-visual sorting based on the productCatSort field and modify the country calculated field such that empty space added to all the country except Others . So that Others country will appear as last portion under the small multiples.

Thanks
VInod