Forum Discussion

bob57's avatar
bob57
Helper IV
6 years ago
Solved

Pivoting Data?

Thanks in advance for your help. Wonderful forum for a rookie like me. I need to create the following table visualization (Employee Hours/Status) based on the information provided further below. Em...
  • Anonymous's avatar
    Anonymous
    6 years ago
     

    Hi bob57 ,

     

    This can again be done through 2 matrix visuals.

     

     

     

     

    Regards,

    Harsh Nathani

     

     

    Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi bob57 ,

 

Is this what you want to visualise at the end, then a matrix can be helpful.

 

 

 

 

Thanks and Regards,

Harsh Nathani

 

Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!

bob57's avatar
bob57
Helper IV
6 years ago

Thank you, but unfortunately, that does not satisfy the the boss' requirement. More specifically, I need 2 tables as they appear below. I only called for the one table in the original post to keep things simple. Also, the "status" does need to remain numeric because, ultimately, they will be displayed using a traffic light KPI. But I'm not worried about that. I just need these two tables.

Hours by Week

Name Week 1 HoursWeek 2 Hours
Joe1511
Bob1416
Sue1511

Status by Week

Name Week 1 StatusWeek 2 Status
Joe23
Bob31
Sue12
  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago
     

    Hi bob57 ,

     

    This can again be done through 2 matrix visuals.

     

     

     

     

    Regards,

    Harsh Nathani

     

     

    Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!!

     

    • bob57's avatar
      bob57
      Helper IV
      6 years ago

      That worked perfectly. Thank you for your effort and prompt response.