Snapshot status for date range to count 'Open Tasks'

Question

Good Morning,

The quality department needs to look at the tasks that where open at a specific time.

Have the created and completion dates used the Target Source on the dates and I can identify what is open and not below image.

Monday                      Month  Year   Open

Monday 4th                March  2019   56

Monday 5th                August 2022   15

Monday from todays date datetimeadd(DateTimeToday(),-tonumber(DateTimeFormat(DateTimeToday(),"%w"))+1, "days")

not sure how to accomplish these two items:

1.- Get the Monday for all past dates

2.- A level of Detail type calculation

Order  Start        End

122     2/25/19   03/11/19  for the selected week starting on  3/4/19 count as Open

And count as open for 2/25/19 & 3/11/19

122     2/25/19   03/11/19  for the selected week starting on  8/5/22 count as Closed

Target source Dates true False.jpg

BAvitia88 · Answer

Let me try to clarify

Input

Production Order Number Started on completed on

122                2/25/19         03/11/19

123                8/1/22           08/15/22

Filter/Question

How many orders where opened on the week starting 3/4/19?

Output

Count=1

The user will select the Monday of the week start and view how many orders where opened during that period.

Hope this helps

Qiu · Answer

@BAvitia88 
I am having difficutly to understand the problem you are facing.

Can you provide a set of sample input and output?