So after composing this desccription I immediately figured it out.

My project dimension in snowflaked, so it uses attributes from a couplle of related tables. One of the related tables did...

Interesting..so this is essentially creating a binary test for selected terms and then selecting the max values from those tests and grouping by employee ID.

That's great!

Thanks for all your help!

Fair enough:

Here is the SQL for a simplified version of the table I am working with. Note that the "field_code" and "person_id" fields would both be foreign keys in the...