Forum Discussion

Anonymous's avatar
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 id, and rating)  which is equivalent to below table.

There are two disciplines, under each there are several skills.

Employee to meet this position requirements (above table) should be rated in the same way (1 for L, 1 for TB, 2 for M, etc.)

I want to compare profile table with employee ratings and conditionally change the color of boxes which are meeting position requirement.

 

I want to create matrix which will be looking like this 

Red skills are this for which employye rating is the same.

 

I am wondering how to compare table with profile and this with employee rated skills,

 

Kind regards

Need Help

5 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Yes, but how to compare these two tables, with profile and employee ratings and show it as matrix

  • Anonymous's avatar
    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's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Anonymous ,

      thank you for your message.

       

      These are my tables:

       

      Assessment

      IDEMP_IDSKILL_IDRATE
      1113
      2132

       

      Employee:

      IDEMP_NAMEEMP_ROLE
      1Kamil KowalskiJunior Specialist
      2Anna NowakJunior Specialist

       

      Skills:

      IDSKILL_NAMESKILL_CATEGORY
      1PythonProgramming
      2SQLProgramming

       

      And manualy created table with profiles:

      IDPOSITIONSKILL_IDRATE
      1113
      2131

       

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

       

      Kind regards

      • Anonymous's avatar
        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