Creating the data model for below data sets

[SK28]

Hi,

I have two Tables

	Table A				Table B
ID	status			ID	Date month	Deployed (Y/N)
1	Completed			1	Mar-23	Y
2	Completed			2	Mar-23	Y
3	Completed			3	Apr-23	Y
4	Completed			4	Apr-23	Y
5	InProgress			5	Apr-23	Y
6	InProgress			6	May-23	Y
7	InProgress
8	InProgress
9	InProgress
10	InProgress
11	deployed
12	Deployed

we have a common field ID as the Connection

 we don't have by month data in Table A and only Month data in Table B

the requirement here is - only for ID's that are Completed (4) records in Table A to be mapped with the Table B

A bar chart or a table

which shows by Month, Can anyone helps me with this logic please

Output
Date	Count of ID's with Status Completed	Count of ID's which are deployed
Mar-23	4	2
Apr-23	4	3
May-23	4	1
Note:

[tataharier702]

How do you have the temper to wait 3 weeks for a reply when you've been given a month to deliver something.. I'll wait a day, then email at the top and bottom of every day after that until I get a reply. Every 3 days with no reply, I'll go up a level in management to the boss of the person I'm emailing, and CC one level higher of my own management chain.

ppssppgold.one

pikashow.fyi