Forum Discussion

hazeltine's avatar
hazeltine
Regular Visitor
2 years ago
Solved

Custom sort legend issue

I am trying to reorder the legend and the order of stacked bars for this chart.   I added a new column with numbers to create custom sort order, then did sort by column "Custom Sort (Job rela...
Need Help
  • vicky_'s avatar
    vicky_
    2 years ago

    The job related stress column should be OK - it's what's in your "Custom Sort (Job related stress)" column that would be causing issues.

    Here's how i would debug - create a simple table and put Job related stress (don't summarize) and distinct count of Custom Sort (Job related stress) in the table and sort by the count - this should help you find which specific values for Job related stress are causing issues. You can then fix the sort column to make all the values unique. Note - blank values will count towards "duplicate values" for the purposes of sorting.

     

     

vicky_'s avatar
vicky_
Icon for Super User rankSuper User
2 years ago

The job related stress column should be OK - it's what's in your "Custom Sort (Job related stress)" column that would be causing issues.

Here's how i would debug - create a simple table and put Job related stress (don't summarize) and distinct count of Custom Sort (Job related stress) in the table and sort by the count - this should help you find which specific values for Job related stress are causing issues. You can then fix the sort column to make all the values unique. Note - blank values will count towards "duplicate values" for the purposes of sorting.