Dear all,
I want your help in that, I have attached an excel sheet with two columns I want to make a workflow to add a new output column with a name of "حالة العميل" with these conditions if
Avg+30 ≥ last order > Avg then write in "حالة العميل"'s column = "منقطع حديثا" with a blue fill cell
else if
last order ≤ Avg then write in "حالة العميل"'s column="زبون" with a yellow fill cell
else if
last order>Avg+30 then write in "حالة العميل"'s column="زبون منقطع"
Any help in that please?
Thanks in advance for your kind support.
Solved! Go to Solution.
Hi @Feras95p ,
the conditions translate to Alteryx very straightforward:
IF [Avg] + 30 >= [last order] AND [Last order] > [AVG] THEN
'case 1'
ELSEIF [Last order] <= [Avg] THEN
'case 2'
ELSEIF [Last order] > [Avg] + 30 THEN
'case 3'
ELSE
'not defined'
ENDIF
Simply add a Formula tool, add a new column add insert the formula - I simplified the results a bit.
Hope this is helpful.
Best,
Roland
Great! it works thanks a lot, but how I can make each case with a different color cell, it that possible?
hi @Feras95p,
attached a workflow that follows your rule.
I noticed that the last rule has no colour.
If you want to add one colour more, you can do that within the table tool
Let me know if you have any questions
Best,
Vianney