Cascading sort options

[Reena]

Hi,

I have a visual with multiple columns - Column A, Column B, Column C… Is there a way to sort these filters in any order like - sort by Column A, then by Column B, then by Column C (or sort by Column B, Column A, Column C) in the dashboard view for users based on their needs? Currently, the sorted data is reset when data is sorted based on a new column.

Thanks!

[Max]

Currently this is not possible natively.

There are some workaround with calculated fields which I think is what could get you there.

Sorting an axis based on calculated field

Hi @harmen - This is a great suggestion, this type of advanced sorting is not possible today. Here is a workaround you can use. Step 1 - Create a calculated field to switch the dimension of your chart based on a parameter value c_measure_dim // switch dim order by on parameter selection ifelse( ${pmeasure}='Day of Week',dow, ${pmeasure}='Weather Type',{weather_type}, null ) Step 2 - Create a calculated field to convert your date to a day of week (integer). c_week_day extract('WD',dt) S…

Something I have done before looks like this. Where each field is like a multiple so it will take into account the first field first, then the second, etc.

rank([{client_id} ASC])*10000 + rank([{arrival_month} ASC]) *100

[Nicolas]

Would be a good feature.

[Reena]

Hi Max,

Thanks for your suggestion, this is very helpful!
I have a ‘Table’ visual type in my dashboard which has multiple columns. Would you have any suggestions/workarounds on sorting these columns (similar to sorting in Excel)?

Thank you!

[Asem]

Hi,
Please see this post for a workaround. Its based on the suggestion that Max provided above using a calculated field.
We will also create a feature request for this. thank you.

[Reena]

Hi Asem,

Thanks for your suggestion, could you please post the link to the post for the suggested workaround.

Thank you!

[Asem]

Hi- Not sure why the link didn’t come through. Here it is again:

Sorting on multiple columns.

Thank you.