Challenge #11: Identify Logical Groups
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
nini
8 - Asteroid
10-08-2019
12:03 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
kmcdaniel
8 - Asteroid
10-09-2019
11:13 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
ddiesel
13 - Pulsar
10-10-2019
10:59 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
KT2
7 - Meteor
10-10-2019
11:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Boom.
Sebenius
8 - Asteroid
10-11-2019
12:45 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
erick_irigoyen
Alteryx Alumni (Retired)
10-11-2019
11:20 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
SueDonim
8 - Asteroid
10-11-2019
11:58 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
I had downloaded the data before it all changed, so was working with the larger dataset.
I inadvertently plugged the search values directly in the formulas, rather than link to it. I might redo the exercise to deal with that, but this seems pretty good ATM
Only issue is a discrepancy of 55 trigger complaints (my number is lower), but all the others match. I'm guessing this is an issue with the truncated fields which is probably why the challenge was revised.
Spoiler
Process:
- Replace the complaint row separator of "." with "|" so it's easier to work with
- Add Record ID to allow for grouping
- Revise Record ID with Multi-Row tool such that it only increments if there is a pipe separator
- Flag instances of search term for all 7 permutations of the search term
- Aggregate with Group By Record ID and count all instances of each permutation
- Sum each of the 7 permutations
- Remove double-counting
- Transpose data to get it in columns
- Sort (descending) and Clean-up
- Replace the complaint row separator of "." with "|" so it's easier to work with
- Add Record ID to allow for grouping
- Revise Record ID with Multi-Row tool such that it only increments if there is a pipe separator
- Flag instances of search term for all 7 permutations of the search term
- Aggregate with Group By Record ID and count all instances of each permutation
- Sum each of the 7 permutations
- Remove double-counting
- Transpose data to get it in columns
- Sort (descending) and Clean-up
ArnavS
Alteryx Alumni (Retired)
10-14-2019
09:30 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
sgrabish1
8 - Asteroid
10-15-2019
03:51 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
KatieA
Alteryx Alumni (Retired)
10-17-2019
08:56 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator