Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

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

Looping Thru Records and Applying a Specific Logic

RonGatmaitan
8 - Asteroid

Hi,

 

I need to be able to compute, and eventually sum up, tasks done by employees. This being the case, I am looking to loop thru the records, apply the logic, and then compute.

 

The table is in this format.

 

RonGatmaitan_0-1663379958212.png

 

Do note that certain tasks are still open which should be disregarded.

 

Thank you very much!

11 REPLIES 11
Luke_C
17 - Castor

What are you summing, time? Can you share what the desired output looks like? Can you share the data instead of a screenshot

RonGatmaitan
8 - Asteroid

Hi @Luke_C,

 

Yes, time. :)

 

Here's a sample file.

Qiu
20 - Arcturus
20 - Arcturus

@RonGatmaitan 
What will be the expected output?
Say in your sample data, For user A, complete Task count is 1 and also 1 for user B?

RonGatmaitan
8 - Asteroid

Hi @Qiu.

 

Total time. So, 5 minutes for User A and 1 minute and 30 seconds for User B.

 

Do note that there will be multiple tasks so, there may be a Task 4, where User A will appear again.

Qiu
20 - Arcturus
20 - Arcturus

@RonGatmaitan 
Thank you for the clarfication.
If we calculate the time difference betwteen start and end for User A, it is inddeed 5 minutes.
but it is 2 minutes, rather than 1.5 minutes as you have said. 
Can you kindly explain the logic I am missing?
 and it would be greate if you can upload a data file since the picture is not so good to work with. 😁

RonGatmaitan
8 - Asteroid

Hi @Qiu,

 

Sorry, it really is 2 minutes. Miscalculated on my part. 😁

 

I already uploaded the data for Luke, but here. 😊

 

Thank you!

Felipe_Ribeir0
16 - Nebula

@RonGatmaitan , i dont know if i understood well, but please see if it is it.

 

Felipe_Ribeir0_0-1663459943973.png


If the provided answer helped you to solve the problem/was correct, please accept it as a solution :)

 

Thanks.

 

Qiu
20 - Arcturus
20 - Arcturus

@RonGatmaitan 
Thank you again and sorry about the attachment. Miss it.

I would give a different approach to use Multi-row tool.

0918-RonGatmaitan.PNG

RonGatmaitan
8 - Asteroid

Hi @Felipe_Ribeir0

 

I think you did, fairly well. 😀

 

Let me apply this to actual data. The structure is a bit more complicated than this. I only simplified for easier understanding, but I think I can apply the same logic.

 

Thank you very much!

Labels