Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

data relationships

I have two different tabs on excel. One has employees and amount of hours worked per employee. Another has phases of a project and the amount of hours in each phase as well as the total number of hou...
Anonymous's avatar
Anonymous
Not applicable
8 years ago

We cannot derive that as the current table design has no relationship between these 2 tables and there is no way to find how many hrs Sam spend his effort in each phase AND who contributed for the 12 hrs meeting. The design needs to be changed, to have the relationship and break up to find the above details.

 

Thanks

Raj

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Do you have a suggestion on how to do that?

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    the Employee Table should have the break up of hrs spent for the phase/ per employee. You should include a new column Phase in the Emp table. Then you can make the relationship between these 2 tables basaed on the "Phase" column .

     

    Thanks
    Raj

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      I just did that but my visualizations are still not interacting 

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        Can you please post your revised data model and also share what are trying in the visuals . Please share the PBIX file if you need more help.

         

        Thanks
        Raj