Forum Discussion
Capability profile matrix heatmap
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
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
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