Forum Discussion
"Flag" each month between two dates
Hi,
Try this link - https://drive.google.com/open?id=1dH-QEuEKH27RxBZlg2SoHfX5JL1zT1Cd
Hope this helps.
I appreciate your willingness!
Please use this dropbox link for the sample file (I used Excel for the sample file, hope that is OK). The field "Loss Date" is the start date and the field "altClose Date" is the ending date. Also, if Status is "Final", then the claim record should be excluded from the counts, we are only worried about claim statuses other than "Final" (Open, Reopened).
https://www.dropbox.com/s/6urun199qkosbok/AnalyticsReport%20-%20Copy.xlsx?dl=0
Thank you kindly!
Super UserHi,
Do you only want to see those where the loss date is on or after 1/1/2018 and where the status is other than Final?
Hi Ashish,
I'd like to consider the entire history of this dataset where status is other than Final.
I look forward to learning the technique so I can apply to other projects when needed!
I appreciate your continued help!
- Ashish_Mathur
Hi,
Is this the result you are expecting?
Hi Ashish,
I appreciate your work, this looks promising!
Anyway you can share your techniques and logic please so I can further review?