Rearrange matrix columns

Question

Hi,&nbsp;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 sorting the table by the index column (whole number) but still doesn't work....Do I need to split the Frequency column into 4 separate columns?&nbsp;ThanksJen

idrissshatila · Answer

Hello&nbsp;JLYT&nbsp;,&nbsp;Using the index try sorting the column in the datset with the index then It should work.&nbsp;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 .&nbsp;If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos&nbsp;👍Follow me on Linkedin

jlyt · Answer

Hi&nbsp;Idrissshatila,&nbsp;I sorted the column by the index and still doesn't work?Could it because I have some blanks?&nbsp;ThanksJen

idrissshatila · Answer

JLYT&nbsp;,&nbsp;Now go to the matrix and try sorting by this column that has the values.&nbsp;If I answered your question, please mark my post as solution so it would appeare to others, Appreciate your Kudos&nbsp;👍Follow me on Linkedin

jlyt · Answer

Hi&nbsp;Idrissshatila,&nbsp;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.&nbsp;ThanksJen

Forum Discussion

Rearrange matrix columns

4 Replies

Related content

Rearrange Column Order in Matrix

Split and rearrange columns

Rearrange columns

Table Column Sort/Reorder/Rearrange

Manually reorder rearrange matrix columns