Sort Bar graph

[#1]

Hi All,

I am trying to sort the bar graph, but i didn't get the way to sort in the below screen shot.

We actually get this based on composite field (Querter and Year).

.

Need your support.

Thanks

UMAMAHESWRA REDDY

[Chanty4u]

am not sure,

Try with Match function  in sort tab expression:

=match(Field,' value1','value2') 

[shraddha_g]

Use QuarterStart Field or QuarterStart(DateField) in Sort by Expression

[sunny_talwar · Accepted solution]

May be like this:

Date#(KeepChar(Quarter, '0123456789'), 'MYYYY')

[ganeshsvm]

Best practice is, you should assign PeriodID using Dual() in your Composite field in backend script, This will be useful in sorting & also Date range calculations in the frontend.

something like this,

Dual(Quarter&' '&Year,AutoNumber(Quarter&' '&Year)) as QtrYrPeriod

Regards,

Ganesh

[#6]

Hi Chanty,

i tried that match, wild match as well, it is giving like below, i need year wise sort then quarter wise sort

[shraddha_g]

These are dynamic values You cant hardcode using Match()

[#8]

Hi Sunny,

thanks its working.