Hi All,
I have an excel file that contains data across 20+ columns and 800 rows. This contains data around skill-sets on the group. It is updated using 1 for having the skill and 0 if they don’t.
I want to create a visual that will give me a tabular view (or others if better) of the skills the agents have. I can’t seem to create an uber-type column for these to sit under.
This is an image of the base file. I want to group these columns to get a better view.
Hello @Seamas_O_Brien , hope this message finds you well.
If I understand your problem, my suggestion to group skill columns into a single column, you can utilise the calculated fields functionality to create a new column that combines the values of the skill columns. Begin by navigating to the data preparation section in QuickSight. Here, you will need to click on “Add calculated field” to initiate the process. You can then employ a formula to concatenate the skill columns. For instance, you might use a formula such as concat(ifelse(skill1 = 1, 'Skill1, ', ''), ifelse(skill2 = 1, 'Skill2, ', ''), ifelse(skill3 = 1, 'Skill3, ', '')). This formula will generate a new column that enumerates the skills each agent possesses, effectively consolidating the data into a more manageable format for visualisation.
Please, tell me if this helps you
Hi @Seamas_O_Brien,
It’s been awhile since we last heard from you on this thread, did you have any additional questions regarding your initial post?
If we do not hear back within the next 3 business days, I’ll close out this topic.
Thank you!
