topic Re: Sorting in Management & Governance

Sorting

qliker3 — Fri, 04 Nov 2022 12:59:36 GMT

Hi,

i have data that goes from 0 to 10. I want to create a filter pane that would start at 3 and go to 2. Example:

0 1 2 3 4 5 6 7 8 9 -> 3 4 5 6 7 8 9 0 1 2

how would i do this?

Thanks

Re: Sorting

marcus_sommer — Fri, 04 Nov 2022 13:28:14 GMT

You may apply a conditional function for the sorting like:

pick(match(Field, 3 4 5 6 7 8 9 0 1 2), 0 1 2 3 4 5 6 7 8 9) // with commas instead spaces as value-delimiter

Another method would be to pre-load your values, like:

temp: load * inline [
Field
3
4
...];

then loading your origin data and after it removing the temp-table again. Now you could use the load-order for the sorting.

- Marcus

Re: Sorting

qliker3 — Mon, 07 Nov 2022 15:47:57 GMT

it has set the sorting to 0 1 2 3 4 5 6 7 8 9 instead of 3 4 5 6 7 8 9 0 1 2. How can this be fixed?

Re: Sorting

marcus_sommer — Tue, 08 Nov 2022 06:25:13 GMT

The load-approach like suggested should work but the expression has a logical error because the pick() isn't set right respectively wouldn't be needed for this scenario. Therefore change it to:

match(Field, 3, 4, 5, 6, 7, 8, 9, 0, 1, 2)

- Marcus

Re: Sorting

qliker3 — Fri, 11 Nov 2022 08:48:57 GMT

so my actual sorting is from 0 to 24. And after applying your recent coment i get a weird sorting order:

Regards

Re: Sorting

marcus_sommer — Fri, 11 Nov 2022 08:57:17 GMT

If the range of numbers is different you will need to adapt the sorting-measures appropriate. Further you need to ensure that this sorting is also applied as the first sorting-option.

- Marcus

Re: Sorting

qliker3 — Fri, 11 Nov 2022 09:10:41 GMT

i have set this column as the first sorting option. It works better now but for some reason 10 is on top, everything else is set to the right sorting order

Regards

Re: Sorting

marcus_sommer — Fri, 11 Nov 2022 10:41:04 GMT

This looked like a normal numerical sorting and not like a customized one. Are you sure that you have set the sorting to the expression (and before also checked that the expression is logically and syntactically working because an invalid expression will be ignored)? If you have chosen to apply the sorting per load-order then this option needs to enabled.

- Marcus