Bar chart help

[mahitham]

Hi,
Can any one please help me to derive Added, Removed and Renamed count on the trend like below based on below logic in the backend script.
Added:
Date 11-10-2019 is compared with  Max Date i.e., 20-10-2019
So IDs 6,7,8,9,10,11 are added So count on Trend for Added is 6.
same like Date 15-10-2019 is compared with Max Date i.e., 20-10-2019
So IDs 8,9,10,11 added So count on Trend for Added is 4.
 
Removed :
Date 11-10-2019 is compared with Max Date i.e., 20-10-2019 here
ID=3 is removed so count on Trend for Removed is 1.
 
Renamed:
 Date 11-10-2019 is compared with  Max Date i.e., 20-10-2019 here
for ID=5,Name=E that's renamed as Name =M for ID=5 in 20-10-2019
so count on Trend for Renamed is 1.

 

Expected Output chart:

Please find the attached excel spread sheet.

 
Thanks in advance