Scenario Logic Help

[abhaysingh]

Hi All,

I have two tables Community Test Data Assign and Community Test Data Assign. there are link on the basis of Visit ID,

In assign Table i have Date Submitted Field and in Visit Table i have Date Due field.

I need to calculate below 3 Logic..

1. AssignmentsCompletedCount =  count of DateSubmitted >= startDate And DateSubmitted <= endDate and DateSubmitted <= Visit.DateDue

2. AssignmentsSubmittedLateCount = Count of DateSubmitted >= startDate And DateSubmitted <= endDate and DateSubmitted > Visit.DateDue

3. AssignmentsOverdueCount = Count of Visit.DateDue + Visit.GracePeriod >= startDate && Visit.DateDue + Visit.GracePeriod <= endDate && DateSubmitted == null

Start Date and End Date user will enter..

I need the count of Assignment Completed, Assignement Submitted late, Assignment Overdue in Pie chart..

Can any one help me in this??

thanks

[abhaysingh]

Pls revert..thanks

[abhaysingh]

hey guys any one pls suggest??

[Anonymous]

Is this flag IsDeleted useful for this?

[abhaysingh]

if(AssignmentTask = 'Completed' ,  count({<  DateSubmitted = {'>=$(=vStartDate)  <=$(=vEndDate)'} >} AssignmentTask),

if(AssignmentTask = 'Submitted Late' ,  count({<  DateSubmitted = {'>=$(=vStartDate)  <=$(=vEndDate)'} >} AssignmentTask),

if(AssignmentTask = 'Assingment Overdue' ,  count({<  AssmntOverdueDate = {'>=$(=vStartDate)  <=$(=vEndDate)'} >} AssignmentTask))))

[abhaysingh]

yes False or null to be pick

[Anonymous]

Abhay,

As per this logic

if(num(DateSubmitted)<=num(DateDue),'Completed',

if(num(DateSubmitted)>num(DateDue),'SubmittedLate',

if(IsNull(num(DateSubmitted)),'Overdue'))) as AssignmentStatus,

No null values in case of Overdue...

Tell me what expression you are using now with these status?

Does I need to create grace period as well? On what basis you are creating grace period?

[Anonymous]

oky, share your expression

[Anonymous]

Got it.

Now if your Overdue is not matching then check the joining part of the table whether it wud be outer or right or left...

as your completed and late status task are matching.

[Anonymous]

I am creating some null values for overdue and wud be sharing with you in a while...