Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Custom Sort Axis

Hi all, i have a table of customer satisfaction as below



I would like to build a bar chart of count of response per question and its response detail as below;

 

my question is, how can I sort the X-axis, so that it based on order as below
1. Very Satisfied
2. Satisfied
3. Neutral
4. Dissatisfied
5. Very Dissatisfied

Thank you

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous 
    you can make an index table with these values. 
    Something like

    Index Response
    1 Very Satisfied
    2 Satisfied
    3 Neutral
    4 Dissatisfied
    5 Very Dissatisfied

      then click on Response column and sort it by using the Sort By section and clicking on Index column

    then you can drag this column in the axis of the bar chart.

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi Anonymous 
    you can make an index table with these values. 
    Something like

    Index Response
    1 Very Satisfied
    2 Satisfied
    3 Neutral
    4 Dissatisfied
    5 Very Dissatisfied

      then click on Response column and sort it by using the Sort By section and clicking on Index column

    then you can drag this column in the axis of the bar chart.

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      Thanks Anonymous for your answer. What I did id unpivot the question column and create other response table to sort the axis. Thanks again!

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        No problem 🙂

    • 22LACMT's avatar
      22LACMT
      Helper III
      3 years ago

      how do you stop the auto stop on the visual level ?