Trouble with Task - need to apply a WHERE to a variable but cant seem to

[roattw]

Basic table counting 1) how many cases an MD has over a week and 2) how many of those cases were "treated"

I want to run a task to send an email with summary tables.  Works well but I cant seem to combine them into one summary variable/table.  I have to do them independently.  But the counting of treated requires an additional "Where" filtering that I cant figure out how to apply.

Below are the two tables generated and emailed:  "MD No of Cases"  and "MD cases Treated"  .   I would like to somehow combine variables A and B and have just one variable reported as in the last image.

 

 

PREFERRED:

 

AS always, your people are my heroes.

 

[CoopperBackpack]

Hello @roattw,

I used the following approach (not sure that it is optimal): I used 2 variables similar to your example and added an empty 'Treats' field which is populated by a loop. 

Please note that I used Left join in the 'Update' block because not all the 'MD' will have 'Treated contains Yes'. So, the Inner join can skip some 'MDs'.

 

Tested on the following data set:

 

Here is the result:

[roattw]

Man, I appreciate your help so much.  That worked.  Can we Venmo you funds when you help so much?  Final solution in case someone else can use it.  Last thing I could use for it is to be able to add the date range to the email body.  Have the Difference between UTC run timestamp - 7 days date so the email would read:

Report from "DATE1 (UTC Timestamp - 7 days)"  to  "DATE2  (Report timestamp)"

Tried to make a new variable to receive report timestamp and another to receive timestamp - 7 days, but failed first attempt.  Couldnt find a "date minus" function.