Forum Discussion

JLYT's avatar
JLYT
Frequent Visitor
3 years ago

Rearrange matrix columns

Hi,   How can I arrange the columns to be Never, Sometimes, Often, Always? These are values in a column called 'Frequency'. I have tried adding an index column so that Never = 1 and so on. Then so...
Need Help
Idrissshatila's avatar
Idrissshatila
Icon for Super User rankSuper User
3 years ago

Hello JLYT ,

 

Using the index try sorting the column in the datset with the index then It should work.

 

so you click on the column in the table in the dataview, and sort by (as shown in the screenshot) and choose the index column .

 

If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍

Follow me on Linkedin

  • JLYT's avatar
    JLYT
    Frequent Visitor
    3 years ago

    Hi Idrissshatila,

     

    I sorted the column by the index and still doesn't work?

    Could it because I have some blanks?

     

    Thanks

    Jen

    • Idrissshatila's avatar
      Idrissshatila
      Icon for Super User rankSuper User
      3 years ago

      JLYT ,

       

      Now go to the matrix and try sorting by this column that has the values.

       

      If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos 👍

      Follow me on Linkedin

      • JLYT's avatar
        JLYT
        Frequent Visitor
        3 years ago

        Hi Idrissshatila,

         

        I am fairly new to this so sorry about all these silly questions! My matrix valus is using count of users, and the frequency is in the column. So when I sort the matrix, I can only choose to sort by the value (count of userid) which does not affect the frequency column arrangement.

         

        Thanks

        Jen