Forum Discussion

Anonymous

Not applicable

6 years ago

Capability profile matrix heatmap

Hi, I want to create capability profile matrix on which I could compare employee skills with requirements for some job position. I manually created table with three columns (skill id, discipline...

Anonymous

Not applicable

6 years ago

Hi Anonymous,

I think it is possible through customize and measure formula, but it requires some tricks on calculation measure formula coding and conditioner color formula measure fields.

Can you please share some dummy data with a similar data structure to test and coding formula?

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

Anonymous
Not applicable
6 years ago
Hi Anonymous ,
thank you for your message.

These are my tables:

Assessment
ID EMP_ID SKILL_ID RATE
1 1 1 3
2 1 3 2

Employee:
ID EMP_NAME EMP_ROLE
1 Kamil Kowalski Junior Specialist
2 Anna Nowak Junior Specialist

Skills:
ID SKILL_NAME SKILL_CATEGORY
1 Python Programming
2 SQL Programming

And manualy created table with profiles:
ID POSITION SKILL_ID RATE
1 1 1 3
2 1 3 1

Tables are connected in snowflake schema with assessment table in center.

Kind regards
- Anonymous
  Not applicable
  6 years ago
  HI Anonymous,
  
  I'd like to suggest you create a calculated table to extract and merge all skill category and employee roles, then you can and add a new column to configure the main category of these values.
  
  After these steps, you can use employee id on two, new table main categories and detail value(employee role, skill type) as column write a measure to use current value(employee id and skill category) to lookup and summarize correspond rate value.
  
  Regards,
  
  Xiaoxin Sheng