Hi All, I am trying to sort my x-axis values on roles (see screenshot attached) not on the default sort options available in Analyzer.
I read a previous note from 2017 that told me to use CASE to sort, so I did:
CASE split_detail
WHEN 'CEO'THEN 1 WHEN 'Head of Business' THEN 2 WHEN 'key management personnel(KMP)' THEN 3 WHEN 'Other Executives/general managers' THEN 4 WHEN 'Senior Managers' THEN 5 WHEN 'Other managers' THEN 6 END
However, when I put this equation into the sort field, it dodn't sort in the way I wanted. Any help is greatly appreciated.
Thanks
Ben