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

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!

Output

Accepted answers

alisonpitt

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

All comments

alisonpitt

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703