Manually Sort Columns in Bar Chart.....super simple I know, I know

[david lopez]

Hi Community,

 

Trying to figure out how to manually sort bar chart in spotfire, ideally I'd like to have it sorted in as such....

Executive

Director

Manager

Analyst

Associate

the only way I can seem to sort it is by value.

 

Any help would be greatly appreciated.

 

Cheers,

david

[Fabian Duerr]

David,

you can create a calculated column using the 'case function' to set the sort order and then put this on the category axis. Let's call it 'Sort Order':

case

when [Mgr Level] = 'Executive' then '1'

when [Mgr Level] = 'Director' then '2'

when [Mgr Level] = 'Manager' then '3'

when [Mgr Level] = 'Analyst' then '4'

when [Mgr Level] = 'Associate' then '5'

else 'to be defined'

endHope this helps!