Advanced Certification Exam Prep Guide - Practice Question 6

[sean1994]

The screenshot below is the original question and I'm getting 38 as the end result. May someone please help me identify where went wrong in my workflow (see attached)?

Spoiler

Spoiler

The correct answer is 39.

[Qiu]

@sean1994 
You can check this post.
But I still can not really get the correct answer if I dont change the tool sequence of your flow. Still looking.
https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Advanced-Certification-Exam-Pr...

[gawa · Accepted solution]

@sean1994 Two pit falls.

1) DateTime tools

You specified wrong format: 'mm' is for minutes, and 'MM' is for month. You wrote 'mm' where it mut be 'MM'. That's why [TimeDiff] is not properly calculated.

yyyy-mm-ddThh:mm:ss

Here is the correct format.

2) Filter condition of "Within 10 minutes"

You need to include the record having [TimeDiff]=10, too. So operand shall be '<=' instead of '<'.

With the above correction, you will get the correct answer.

[Qiu]

@gawa 
Nice catch. I was also suspecting the date time format. Thanks.

[sean1994]

Thank you, Gawa!