Hello
I have a fixed teams which I would like to count the values of issues (table 1) and production (table 2) by dates.
Teams |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
9 |
10 |
The dates are common values between the tables.
Table 1 | ||||
Team | Year | Month | Day | Issues |
2 | 2020 | 1 | 23 | 1 |
2 | 2020 | 1 | 25 | 2 |
3 | 2020 | 1 | 10 | 1 |
4 | 2020 | 1 | 11 | 3 |
Table 2 | |||
Production | Year | Month | Day |
457 | 2020 | 1 | 23 |
600 | 2020 | 1 | 24 |
550 | 2020 | 1 | 25 |
250 | 2020 | 1 | 10 |
500 | 2020 | 1 | 11 |
I would like as a result a table to count the values even if the team had no issue on that day. It should simply put 0 on that date and only count the production. I attached the images of my tables.
Result | |||||
Teams | Year | Month | Day | Count 1 | Production |
1 | 2020 | 1 | 23 | 0 | 457 |
2 | 2020 | 1 | 23 | 1 | 457 |
3 | 2020 | 1 | 23 | 0 | 457 |
4 | 2020 | 1 | 23 | 0 | 457 |
5 | 2020 | 1 | 23 | 0 | 457 |
6 | 2020 | 1 | 23 | 0 | 457 |
7 | 2020 | 1 | 23 | 0 | 457 |
8 | 2020 | 1 | 23 | 0 | 457 |
9 | 2020 | 1 | 23 | 0 | 457 |
10 | 2020 | 1 | 23 | 0 | 457 |
1 | 2020 | 1 | 24 | 0 | 600 |
2 | 2020 | 1 | 24 | 0 | 600 |
3 | 2020 | 1 | 24 | 0 | 600 |
4 | 2020 | 1 | 24 | 0 | 600 |
5 | 2020 | 1 | 24 | 0 | 600 |
6 | 2020 | 1 | 24 | 0 | 600 |
7 | 2020 | 1 | 24 | 0 | 600 |
8 | 2020 | 1 | 24 | 0 | 600 |
9 | 2020 | 1 | 24 | 0 | 600 |
10 | 2020 | 1 | 24 | 0 | 600 |
I hope someone can help me with this doubt.
Many thanks.
Solved! Go to Solution.
Hi @imadZidan ,
Thanks a lot for your help. It was a very brilliant solution.
Very happy with this solution.
Best regards,
Wilson