I have a calculated field looking at the time between invitation and enrollment and moving them into a bucket based on the number of days it took to move from invitation to enrollment. I have the following calculation:
datediff(inviteddate,enrolleddate)=1,'1',datediff(inviteddate,enrolleddate) = 2,'2', datediff(inviteddate,enrolleddate) = 3,'3', datediff(inviteddate,enrolleddate) = 4, '4',
datediff(inviteddate,enrolleddate) = 5, '5',
datediff(inviteddate,enrolleddate) = 6, '6',
datediff(inviteddate,enrolleddate) = 7, '7',
datediff(inviteddate,enrolleddate) = 8, '8-15',
datediff(inviteddate,enrolleddate) = 9, '8-15',
datediff(inviteddate,enrolleddate) = 10, '8-15',
datediff(inviteddate,enrolleddate) = 11, '8-15',
datediff(inviteddate,enrolleddate) = 12, '8-15',
datediff(inviteddate,enrolleddate) = 13, '8-15',
datediff(inviteddate,enrolleddate) = 14, '8-15',
datediff(inviteddate,enrolleddate) = 15, '8-15',
datediff(inviteddate,enrolleddate) = 16, '16-30',
datediff(inviteddate,enrolleddate) = 17, '16-30',
datediff(inviteddate,enrolleddate) = 18, '16-30',
datediff(inviteddate,enrolleddate) = 19, '16-30',
datediff(inviteddate,enrolleddate) = 20, '16-30',
datediff(inviteddate,enrolleddate) = 21, '16-30',
datediff(inviteddate,enrolleddate) = 22, '16-30',
datediff(inviteddate,enrolleddate) = 23, '16-30',
datediff(inviteddate,enrolleddate) = 24, '16-30',
datediff(inviteddate,enrolleddate) = 25, '16-30',
datediff(inviteddate,enrolleddate) = 26, '16-30',
datediff(inviteddate,enrolleddate) = 27, '16-30',
datediff(inviteddate,enrolleddate) = 28, '16-30',
datediff(inviteddate,enrolleddate) = 29, '16-30',
datediff(inviteddate,enrolleddate) = 30, '16-30',
datediff(inviteddate,enrolleddate)> 30, '31+', '-1')```
so if the invitation was never accepted they would show up in the "-1" bucket. Is there a way to add these unaccepted invitations back into the main buckets to show the number of unaccepted invitations instead of having all the unaccepted invitations show up in "-1"?
Aucun commentaire:
Enregistrer un commentaire