Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have below data:
Actual Data
Cust,type,trans_date,start_date,end_date
C1,W,01/02/2019,01/01/2019,01/31/2019
C2,W,02/06/2019,01/02/2019,02/28/2019
C1,W,01/03/2019,01/01/2019,01/31/2019
Result Data:
Cust,type,trans_date,Records_IN_DateRange
C1,W,01/02/2019,2
C2,W,02/06/2019,1
C1,W,01/03/2019,2
What will be the Set Analysis function for calculating Records_IN_DateRange column.
something like count({<trans_date ={ ">=start_date<=end_date" }>}1) for each row.
How exactly are you getting 2 for the two C1s? Is it because there are two rows for C1 and for both the rows the trans_date falls between start and end date?
Yes