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

[Brett_Bleess]

Mahitha, just FYI, there is no spreadsheet attachment on your post, just the image screenshot, which makes it a bit difficult for folks to try to play with things, as they would have to recreate that...  I think further clarification may be necessary as well, as I cannot really follow what you are trying to do here, an example app or anything additional may help someone come up with some further guidance for you.  

Regards,
Brett