Forum Discussion
Top 3 Ranking of multiple fields in same table
I have multiple columns/fields showing how many times a survey respondent selected a skill. For each respondent I have a row of text. I'd like to visualze the top three skills selected across all my ...
Hi kbraga ,
The code I sent you should work. Just select the columns member and organization and unpivot all other columns, if you click with right mouse buttom on them you will see this option.
I hope it helps,
Ricardo
If I have other data in the table, would I need to add this to the same table or creat a new one?
If you wanna do it on the same table, just select all the columns you don't need to unpivot. Also, you can select the columns you want to unpivot, just the opposite.
The first option seems more apropriate for you if you can add (more answers/questions) or change the column labels.
Ricardo