Challenge #11: Identify Logical Groups

[KevinW]

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[Paul-Evans]

Here's my solution:

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[sann0638]

Done!

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[otresca]

Solution

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[enci1017]

Solution to Challenge 11, somehow my number is slightly higher than the posted solution。 Any though why?

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[GiuseppeC]

Hi @enci1017,

With your solution, a record that falls into the "Tones + Screen + Trigger" bucket, would also fall into all other buckets. This is due to the fact that the Formula tool evaluates all the formulas you have written independently anyway.

When your "IF THEN ELSE" statement is true for the "Tones + Screen + Trigger", it is also true for all other buckets separately. Hence, results for the "Tones + Screen + Trigger" bucket are correct, but you are over-counting all other buckets.

Hope this helps.

[GiuseppeC]

Was going mad for getting different results, until I realised there are duplicate records with the same Field_6 description and used a RecordID to group by, rather than grouping by Field_6!

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[msicak]

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[ipeng]

Challenge 11 Solution Attached

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.

[KaneG]

This would require less tools if I searched for the words, but one of the things I love about Alteryx is the ability to change the shape of the data so easily.

Spoiler

This post has been edited by Community Moderation to redact sensitive attachments. The original attachment has been replaced by post_placeholder.txt.