topic Re: Display values in numerical order in text in App Development

1

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

martinpohl — Fri, 13 Mar 2020 09:35:47 GMT

create an inline table:

Sort_order:

load

dual(Text,Sort) as Region;

load * inline [

Text,Sort

East,1

West,2

South,3

North,4

];

So your Region field is dual, text to show, sort number to sort by.

It's like a month, jan = 1, feb = 2 and so on...

Regards

jgreen95 — Fri, 13 Mar 2020 09:51:20 GMT

I need to be able to sort by the Pass % not by the number associated to the region

Aditya_Chitale — Fri, 13 Mar 2020 09:56:20 GMT

Hi,

Under the sorting tab, select 'sort by expression' option and pass your % expression in it

Regards,

Aditya Chitale

martinpohl — Fri, 13 Mar 2020 09:59:18 GMT

maybe something like

avg(total <Region> [Pass%])

as I unterstand that there are many values for Region / Subregion