Multi-row formula to identify changing values

anujarora1

Hi Experts,

I am new to Alteryx and facing a difficulty with the below.

I have summarized my issue with a hypothetical example. In the below table, I have a color 'Red' which has two ID's (ID 1, 2) having set of values (same or changing). In my original problem, I have many different colors and my goal is to identify/flag all those colors which have changing values, like in the example below. Even if one value is different than the rest, I want to highlight each row of color 'Red'.

Thanks in advance!

Color	ID	Value
Red	1	100
Red	1	100
Red	1	100
Red	1	100
Red	1	100
Red	2	100
Red	2	80
Red	2	60
Red	2	40
Red	2	20

atcodedog05

Hi @anujarora1 

Here is how you can do it.

Workflow: Checking on Color and ID

1. Using summarize tool groupby color and ID to distinct values count.

2. Using formula if distinct value count >1 then flag changing value as 1.

3. Using join to join back the flag to the main on color and id.

4. Using table applying column rule to highlight values of changing value.

Or checking only on color is values changing

Hope this helps : )

changing values.yxmd

changing values - only color.yxmd