topic Re: Custom sort? in App Development

Custom sort?

gauravgg — Fri, 15 Sep 2017 07:12:15 GMT

Hi all

I have a field as follows

PricePointer

17-Budget

18-Budget

17-Sept

17-May

16-Budget

17-Opening

17-Colsing

I want to custom sort this on x axis

16-Budget

17-Budget

17-Opening

17-Closing

17-Sept

17-May

18-Budget

Can anyone help me

thanks in Advance

Re: Custom sort?

shraddha_g — Fri, 15 Sep 2017 07:14:36 GMT

In sort by Expression

Try,

pick(wildmatch(PricePointer,

'16-Budget',

'17-Budget',

'17-Opening',

'17-Closing',

'17-Sept',

'17-May',

'18-Budget'),1,2,3,4,5,6,7)

Re: Custom sort?

gauravgg — Fri, 15 Sep 2017 07:20:13 GMT

Hi Shraddha

but this sort should be dynamic

it should sort by Year then the order should bb Budget ,Opening,Closing,and within months it sholud sort by Month(As jan to Dec in order)

Re: Custom sort?

shraddha_g — Fri, 15 Sep 2017 07:24:29 GMT

did you try checking numeric & Alphabetic to ascending order?

Re: Custom sort?

gauravgg — Fri, 15 Sep 2017 07:27:43 GMT

yes i tried,

it is not working

Re: Custom sort?

shraddha_g — Fri, 15 Sep 2017 07:35:27 GMT

can you share sample app?

Re: Custom sort?

gauravgg — Fri, 15 Sep 2017 07:41:37 GMT

no ,it's on server

I do not have rights

Re: Custom sort?

vinieme12 — Fri, 15 Sep 2017 07:47:34 GMT

Two Options either sort by expression using Match( or create a sortOrder for this field in script

Option1: example

PricePointer_SortOrder:

LOAD * INLINE [

PricePointer, PP_SprtOrder

16-Budget,1

17-Budget,2

17-Opening,3

17-Closing,4

17-Sept,5

17-May,6

18-Budget,7

];

Then in Chart use sort by expression and add =PP_SprtOrder

Option 2:

Sort by Expression

=Match(PricePointer,

'16-Budget',

'17-Budget',

'17-Opening',

'17-Closing',

'17-Sept',

'17-May',

'18-Budget')

Re: Custom sort?

shraddha_g — Fri, 15 Sep 2017 07:48:32 GMT

Check