Sort by Pivoted Columns

Current sort function only allows sorting by the total across a row in a pivot table. It would be helpful to be able to sort by each column in the pivot rather than the total of the row. This feels feasible given that its just the option to ORDER BY a different column after the query is compiled.

Hi Jesse,

Welcome to Holistics Community! :rocket:

We appreciate your suggestion on the pivot table sorting feature. It’s been added into our backlog for future improvements. If you have any other feedbacks or suggestions when using Holistics, please feel free to share them with us.

Cheers,
Phuong.

It would be really great if the end user could sort by any column in a pivot table. The functionality I’m looking for is just like the sorting functionality in the Data Table visualization.

1 Like

Good to know there is +1 request about pivot table’s sort function, @Becca_Perry!

Could you share some examples of how you want to sort in a pivot? (a screenshot would be helpful).

As you may have known, right now you can do some basic sorting with multiple rows and columns in pivots. Let me know if you have any further use-cases :slightly_smiling_face:

What we’d like to be able to do is sort by the values in one of the pivoted columns. Here’s a toy example –

Dataset
Screenshot 2024-09-04 at 9.16.07 PM

Desired types of sorting – in this case the user hypothetically wants to be able to sort by each fruit to see which buyers bought the most of each fruit.
Screenshot 2024-09-04 at 9.15.29 PM

2 Likes

This is awesome. Thanks for the detailed example, Becca :+1:

I see, it’d be very useful to be able to sort in each column item by its value.

^May I also confirm with @Jesse_Wasily, that this is your intention as well, Jesse?