topic Re: How to order table field after a specific value? in App Development

How to order table field after a specific value?

Ferdie — Mon, 20 Dec 2021 21:32:42 GMT

I recently added an ▲ symbol before the numbers in my 'diff' column. Sorting, however, is not working properly right now. Is it possible for me to let the column ignore the ▲ symbol and just use the numbers after it for ordering it descending/ascending? I know it's possible to just add the ▲ after the numbers, but that looks all over the place if I'm dealing with different lengths of numbers, so I rather have it in front.

Thanks already

Re: How to order table field after a specific value?

mfarsln — Tue, 10 Mar 2020 12:21:29 GMT

Hi,

In the sorting options, set it to 'by expression'. Then sort it by your diff measure expression.

Re: How to order table field after a specific value?

Ferdie — Tue, 10 Mar 2020 12:28:02 GMT

Hi there,

I only have two options in the Sorting section: Nurmeric or Alphabet sorting

Re: How to order table field after a specific value?

mfarsln — Tue, 10 Mar 2020 12:33:52 GMT

Can you share sample data?