I have Data as below, When I select any two dates, I need how many ids has the target date got changed, I was trying with the above approach and unable to achieve.( May be i'm not able to do it).
Can you please suggest the way to do this. I need another Date field as CLOSED DATE for my date range selection.
Say if I select DATE_UNIT = '3/Apr/2018' and CLOSED DATE = '2/Jul/2018' I need count as '1' as the target_date got changed from 31/Jul/2018 to 31/Aug/2018.
Similarly for DATE_UNIT = '1/May/2018' and CLOSED DATE = '1/Jun/2018' I need count as '1' as the target_date got changed from 31/Jul/2018 to 31/Aug/2018.
Same for 1/May/2018 to 2/Jul/2018
For 3/Apr/2018 to 1/May/2018 the count of ID should be '0' as the target date didn't got changed.
Data is insufficient. Add your CLosedDate and put some more data in your table and upload. How do you know for that DATE_UNIT the target is changed? How would you identify that.
Where is your Closed Date field?