Forum Discussion

kbraga's avatar
kbraga
Helper I
6 years ago

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 ...
Need Help
Tips and Tricks
kbraga's avatar
kbraga
Helper I
6 years ago

Yes, apologies, I also need to be able to filter by Organization Code. I've updated the dummy data. So, the question I need to be able to answer interactively is for each organization, what are the top three skills their members obtained. I usually use a slicer to filter by organization. 

 

Member CodeOrganization CodeSkill: BusinessSkill: CommunicationSkill: ConsultingSkill: Cultural AwarenessSkill: FinanceSkill: PatienceSkill: HRSkill: Meeting Skills Skill: RecruitmentSkill: Computers
1234A Communication Cultural AwarenessFinancePatienceHR RecruitementComputers
1235BBusiness Consulting FinancePatienceHRMeeting Skills Computers
1236CBusinessCommunication Cultural Awareness PatienceHRMeeting SkillsRecruitement 
1237D CommunicationConsulting Finance HRMeeting SkillsRecruitementComputers
1238ABusiness ConsultingCultural Awareness Patience Meeting SkillsRecruitementComputers
1239B Communication Cultural AwarenessFinance HR RecruitementComputers
1240CBusiness Consulting FinancePatience Meeting Skills Computers
1241DBusinessCommunication Cultural Awareness PatienceHR Recruitement 
            
camargos88's avatar
camargos88
Community Champion
6 years ago

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

  • kbraga's avatar
    kbraga
    Helper I
    6 years ago

    If I have other data in the table, would I need to add this to the same table or creat a new one? 

    • camargos88's avatar
      camargos88
      Community Champion
      6 years ago

      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