Hi Team,
Hope you are well.
I need help. I have this excel function which i need to replicate into alteryx. Can you please help?
thanks
IF(B3="BELOW THRESHOLD STABLE",0,IF(B3="ABOVE THRESHOLD STABLE",1,IF(B3="ABOVE THRESHOLD FLAG",2,0)))+IF(C3="BELOW THRESHOLD STABLE",0,IF(C3="ABOVE THRESHOLD STABLE",1,IF(C3="ABOVE THRESHOLD FLAG",2,0)))+IF(D3="BELOW THRESHOLD STABLE",0,IF(D3="ABOVE THRESHOLD STABLE",1,IF(D3="ABOVE THRESHOLD FLAG",2,0)))+IF(E3="BELOW THRESHOLD STABLE",0,IF(E3="ABOVE THRESHOLD STABLE",1,IF(E3="ABOVE THRESHOLD FLAG",2,0)))+IF(F3="BELOW THRESHOLD STABLE",0,IF(F3="ABOVE THRESHOLD STABLE",1,IF(F3="ABOVE THRESHOLD FLAG",2,0)))+IF(G3="BELOW THRESHOLD STABLE",0,IF(G3="ABOVE THRESHOLD STABLE",1,IF(G3="ABOVE THRESHOLD FLAG",2,0)))+IF(H3="BELOW THRESHOLD STABLE",0,IF(H3="ABOVE THRESHOLD STABLE",1,IF(H3="ABOVE THRESHOLD FLAG",2,0)))
I would like to create the column I ,"Weighted Score" in the below excel file.
Please find attached,
Thanks,
Solved! Go to Solution.
Hi @sriniprad08
Click on KPI 1 it should get selected like below. Then you can click on create or edit.
Hope this helps : )
Hi @sriniprad08
This interactive lesson would be helpful.
https://community.alteryx.com/t5/Interactive-Lessons/Building-Tables/ta-p/553696
Hope this helps : )
Hi @atcodedog05 ,
Please find attached. not sure why i am not getting the Apply to data only option as of yours in my alteryx table.
Also do we need to define rules individually for all the KRI's? like you did for KR1, KR2 etc.. thanks
Hi @sriniprad08
You have clicked on row rule you need to click on column rule. Refer to the interactive lesson.
@sriniprad08 wrote:
Also do we need to define rules individually for all the KRI's? like you did for KR1, KR2 etc.. thanks
Yes you would need to define for each.
There is actually a quick workaround to apply this conditional formatting to all fields instead of doing them one at a time.
1. Delete the connection right before the table tool and run the workflow. This will throw an error but that's ok.
2. Click on the table tool and you'll notice that the only available column to apply a rule to is the Dynamic or Unknown Fields. This is what we will be using to apply this rule to everything.
3. Now you can add three different conditional formatting rules using a formula to define the red/yellow/green values. I add a ToString function to the formula to prevent errors with the numeric fields.
4. Now connect your data back to the table tool, and you will see that these rules are applied to each incoming field.
Output after running workflow:
Cheers!
Phil
User | Count |
---|---|
84 | |
65 | |
61 | |
49 | |
38 |