Alteryx academy Practice exercise 3

Good afternoon,

I just completed the third practice exercise through Alteryx academy. Does anyone know/understand how the sample/correct answer was generated.

I think my workflow generates the correct answer, but my results do not match the sample correct one. Just curious if anyone can share some light on it. I think the goal is to be able to use the software comfortably which I accomplished but I can't understand what exactly the thought process is to generate the correct answer.

Practice+Exercise+3.yxzp

Preparation

Accepted answers

danilang

Hi @DanielGGreenbaum

In this exercise you're gathering statistics about employee purchases. Lookin at each of the output fields in turn

1. Report ID. One row for each report submitted by an employee in the Initial State input.

2. Total. This is the total cost of the order. For each line item take the (unit cost-discount amount)*quantity+shipping. Note that the discount is given as a percentage so you'll need to do the math to convert that to a discount amount

3. Total Saved. The difference between the total before the discount and the total after, not including the shipping cost

4. The elapsed time from the submission date until the reportID is completely paid off

Hope this helps

Dan

All comments

danilang

Hi @DanielGGreenbaum

In this exercise you're gathering statistics about employee purchases. Lookin at each of the output fields in turn

1. Report ID. One row for each report submitted by an employee in the Initial State input.

3. Total Saved. The difference between the total before the discount and the total after, not including the shipping cost

4. The elapsed time from the submission date until the reportID is completely paid off

Hope this helps

Dan

DanielGGreenbaum

Hello Dan,

Thanks so much for your response. It didn't occur to me that the discount was a percentage, but if you take it as a percentage then the rest of it begins to make a lot more sense. I appreciate the help.

Sincerely,

Cafucati

Here is my attempt on practice exercise 3

Practice Exercise 3.yxmd

LaurieR

richmondbound

Practice exercise 3 solution

Final State - Exercise 3.yxdb

Aaina_Aggarwal

Here's my solution

Practice Exercise 3 Solution.yxmd

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703