Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Snapshot status for date range to count 'Open Tasks'

BAvitia88
8 - Asteroid

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

2 REPLIES 2
Qiu
21 - Polaris
21 - Polaris

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

Can you provide a set of sample input and output?

BAvitia88
8 - Asteroid

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

Labels
Top Solution Authors