use selected field value in chart sorting

[#1]

Hi,

Does anyone know how to use selected field value and do a wildcard search in Chart "Sort by expression"

I tried this

if (GetCurrentSelections(Roadway) like '*Eastbound', milemarker, -milemarker)

During test, the chart continue loading after select a roadway without showing any result

Is the above expression correct? How do I fix it?

Please advise

Regards

[jeevays7 · Accepted solution]

try this.

=if(Roadway like '*Eastbound' or Roadway like 'milemarker' or Roadway like '-milemarker',1,0)

1,0 -> your conditions

[#3]

thank a lot. it works. why just use field name instead of the selected filed value

[jeevays7]

Welcome Cheng Ma,

You can also use getCurrenSelection or getFieldSelection.

Ex: =if(GetCurrentSelections(Roadway) like '*Eastbound' or GetCurrentSelections(Roadway) like 'milemarker' or GetCurrentSelections(Roadway) like '-milemarker',1,0)