34|ALTERYX – Audit Attention


I enjoyed figuring out how to first filter the data to what I needed and then joining it together at the end. This was good practice for focusing more on manipulating the data rather than finding the right tools
AuditChallengeBS.yxmd (17.3 KB)

1 Like


I noticed that a bunch of other people used the absolute function to get the credits. I did not realize that was an option but still found a way to make it work! Thanks for the challenge!

New Workflow1.yxmd (15.2 KB)


Not sure why my values did not want to show negatives for the credits, but it was a good challenge!

1 Like


This was a cool challenge, but if anyone knows how to filter for multiple things at once let me know!
TechHubChallenge#3.yxmd (14.4 KB)

1 Like

Nice. This is for Scott Summers section 4 class

You can you the boolean “AND” in the custom filter section:
image

Learned more about filters and how to make them work together and when they are better to separate to insure correct information.

2 Likes

here’s my solution! great practice, thanks for putting it together!


Here’s what I did!

1 Like

This looks great!

Audit Attention.yxmd (14.6 KB)

1 Like


This was good practice. I originally thought there would be a join at the begining.

AlteryxTechHub1.yxmd (15.3 KB)
This was a good starting practice problem with alteryx. I hadn’t used the ABS formula function yet so that was new!

Love the AV curveball! Thanks for a great challenge!


AuditSolution.yxmd (14.1 KB)

Here is my solution to this challenge.


MeganArnoldAuditAttention.yxmd (15.0 KB)

Here’s my solution:

Here is my solution:

2 Likes

1 Like


This one was fun to figure out as i had to consider taking the absolute value of the balance to get to the right answer