You can get whether the date is within 14 days or not by using 'DATEDIFF('day',ATTR([Due Date]),MAX([Start Dates].[Opened At]))'. As there are more than 1 date for 1 caller id so we will get '*'. Thta's why I have used as max of date. And then you can filter the result to display only less than 14days record. Please check the screenshot and let us know is this you were trying to achieve?
I think you're on the right track, but it's not returning what I would expect:
For John Doe, we have the below REQ/start date ("Due Date"):
REQ # Due Date New Hire REQ123 1/1/2017 John Doe
Then, from our INC table, we see:
INC Opened At Caller ID INC123 1/1/2017 John Doe INC124 1/1/2017 John Doe INC142 1/20/2017 John Doe INC143 1/21/2017 John Doe INC144 1/22/2017 John Doe
So, what I would expect to see is "2", as in he's had "2" incidents submitted w/in 14 days of his start date (5 listed, but the other 3 are <14 days). It seems using the above method, it's just agg'ing the date difference b/t each incident together, instead of telling me each individual incident's relation date to his start date, then I could use filter's / countd's.
Hope this helps,
Without knowing how you want things laid out the below is the simplest example (uploaded a 10.0.3 workbook ex.)
WINDOW_SUM(IF DATEDIFF('day',ATTR([SC RITM (Start Dates)].[Due Date]),MAX([Opened At]))<=14 THEN 1 END)
forum.twbx 26.0 KB