I need to create a bar chart visual which captures data based in 2 seperate tables looking at 2 different dates (with the 'Year' being the X axis).
1. I need the Number of Apps ('App_no') within the 'Apps' table looking at the date variable 'App_In_Date'.
2. I also need to the Number of Apps ('App_no') within the 'TMJ_Checks' table looking at the date variable 'TMJ_In_Date'
So, if the Application was submitted in December 2020 I need that account to show on the 'App_In_Date' X-axis, but this job could have moved into the 'TMJ_Checks' in January 2021 so I would need this count to show on the 'TMJ_In_Date' X-axis,
So 1 count for December 2020 (App_In_Date: Year) and 1 count for January 2020 (TMJ_In_Date:Year)
I hope this makes sense. Any idea how I could go about doing this please?