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.