Hello everyone in the Quicksight Community. I have been working on the insights visual and I have come across an issue. I have an value field say for example Earnings, which consists of both positive as well as negative values. I have my Insights Visual which shows Top Ranked (Top 3) for this field. Now the deal is that, my Insights visual is sorting only for the Top 3 positive values. I want the sorting to be done based on the magnitude including negatives.(Example if I have 77, -115, 195, I want the Insights Visual to show “The top ranked are 195, -115, 77”). I happened to have made a calculated field with abs, that seems to somewhat sort based on magnitude, but using abs means the negative and positive signs (+ or -) are no more displayed by the Insights Visual. I want to sort the visual by magnitude including all signs positive or negative.
Hi Smin
Can you please share some sample data.
Hi @SmiN, there are several approaches, A. Change data type to string and custom sort, B. Create another Sort field, bring it as hidden field and sort on it.
QuickSight authors can configure an off-visual sort to sort the values in a table by a field and aggregation that is a part of the dataset that the table uses but not in one of the table’s field wells. One off-field sort can be configured to a single table at a time.
Use the procedure below to configure an off-visual sort.
To add an off-visual sort to a table
- Open the QuickSight console.
- Open the analysis that you want to work in and navigate to the table that you want to sort.
- Choose the header of any column in the table.
- For Sort by, choose the arrow icon, and then choose Off-visual field.
- In the Off-visual field pane that appears, open the Sort by dropdown menu and choose the field that you want to sort. The image below shows the Off-visual field pane.
Did this solution work for you? I am marking this reply as, “Solution,” but let us know if this is not resolved. Thanks for posting your questions on the QuickSight Community!
1 Like