Learning Formula's sucks!!! IF CONTAINS OR THEN ELSE UGH!

[MaryCann]

Okay.  Pivot Field Names (group).  I have 6 Pivot Field Names (groups)'s.  I'm trying to create another group from just 5 of these.  Problem - is this the best way to combine these groups into 1 group?  How should I end the formula?

.  Second problem.  Within these 5 groups are about 40 Pivot Field Names.  Each of these Pivot Field Names has a score of 0, 1, 2 or 3.  I'm trying just to pull out the 2's and 3's.  So, thinking something like this afterwards:

But, obviously - I don't know what I'm doing.  So, any help is appreciated!  Thank you in advance!

[alisonpitt · Accepted solution]

Hi @MaryCann correct me if I'm wrong but these screenshots look like Tableau, not Alteryx?

[MaryCann]

Oh **bleep**!  I asked in the wrong group!  Thanks!

[DataNath]

Yep, definitely Tableau @MaryCann! That said...

You don't need to restart your 'IF' for every condition, just the first one, so you can use:

IF Contains([Field], X] OR Contains([Field], Y] etc.

In terms of grouping efficiently, surely it'd be quicker to do it the other way round? I.e. If Contains([Field], Z) then 1 else 0, with Z being the single ungrouped measure?

If I'm understanding the question correctly then for the second, you could use something like:

IF [Group Excluding Strengths] = 2 THEN [Pivot Field Names]
ELSEIF [Group Excluding Strengths] = 3 THEN [Pivot Field Names] END