Forum Discussion
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...
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
Do you have a suggestion on how to do that?
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
RajI just did that but my visualizations are still not interacting