I need help with organizing data or desginig new data.
we already have a table with a sample of jobs coming in and with different statuses.
Below is the sample of existing table:
Job ID, Job Number, Completion Date, Status,Analyst Name
111, TW-DH-27, 12/12/2018, Completed, John1
112,TW-DH-28,1/1/2018, Completed, John2
113, TW-DH-29, 12/13/2018, Completed, John1
114,TW-DH-30,1/2/2018, Completed, John2
115, TW-DH-31, 12/14/2018, Completed, John1
116,TW-DH-32,1/21/2018, Completed, John2
Now, I need to give users some kind of flexibility to input # of working days for each month for all analysts in the above table.
So, In the new table, I need Analyst Name, Month Name, # of days worked.
I have some flexibility in the new 2nd table to design. After desigining the 2nd table, I need to join both and see, how many completed jobs are there for each analyst and how many hours worked for each month and year.
Not sure how to design the 2nd table to join to the 1st table. Please help!