Hello
I have a fixed teams which I would like to count the values of issues (table 1) and production (table 2) by dates.
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.
