Thanks for providing a detailed description, desired outcome, and sample workbook.
I'm not sure if this will work for you true datasource, but maybe it can give ideas.
There are likely other ways to go about it, but I attempted it with a date scaffold,
excellently described here:
I feel like the scaffold is necessary because what I think is needed is an independent date field.
I think it will be difficult to plot against the [Work Date] because it would need to compare
the Work Date of one ID against the Paid Date of another ID.
This is the part that may be unwieldy if your data are large:
I did cartesian join of all scaffold dates to all rows of data using a calculated field join of 1=1.
Then I checked if the Scaffold Date was >= of the paid date
and within 30 days of a work date:
IF [Scaffold Date]>=[Paid Date]
DATEDIFF('day',[Work Date],[Scaffold Date])<=30
This could then be summed on the scaffold date.
Please see workbook v2019.2 and sample datasource attached in the Forum Thread:
Thank you so much for your thoughtful reply and my apologies for taking so long to say so. I am going to give this a try next week and report back!
Absolutely no worries at all.
Will look forward to hearing how it goes.