1 of 1 people found this helpful
So one way to do this is to nest your logic statement (at row level) within an IF statement, and only return the ID if true (else NULL) and then COUNTD this (NULLs don't get counted in COUNTD)
so would be something like
COUNTD(IF DATETRUNC('week', [Start_Date])=DATETRUNC('week',[End_Date]) AND Status='Completed' THEN [ID] END)
I've assumed here your dates are by day, so need to be TRUNC'ed to Week to compare
You can then drag your start date into your Rows/Shelf and likewise with the new calculated field to get your plot
Hope that does the trick, but please post back if not.