Table Tool Conditional Formating based on the dynamic Row/Cell Value

Question

Dear Experts,

Trying to figure out if there is a way to apply conditional formating using Table Tool for the following cases.

I assume it would be an individual column formula for each customer that would reference the value indicated in the "ORDER_COUNT_2STDDEV_BELOW" and compare it to each value in the column?

Customer 1: Highlight Column Value in yellow where it's equal or less than the value indicated in "ORDER_COUNT_2STDDEV_BELOW". In this case it would be all the values equal or less than 231

Customer 2:

Highlight Column Value in yellow where it's equal or below the value indicated in "ORDER_COUNT_2STDDEV_BELOW".

In this case it would be all the values equal or less than 6

Bold Last 4 Total Rows: (Row formula used)

REGEX_Match(ToString([_currentfield_]), 'Total|ORDER_COUNT_MEAN|ORDER_COUNT_2STDDEV_BELOW|ORDER_COUNT_STDDEV')

Desired Output:

Thank you in advance!

ALTRX_TBL_TOOL_CLMN_CNDTNL_FRMTNG.xlsx

ALTRX_CNDTNL_FORMATING.yxmd

ValeriaK · Answer

FrederikE, if there is a way to reference two before last row with the Sample Tool? Thank you!

ValeriaK · Answer

Thank you FrederikE! Unfortunately when applied to the whole dataset, your solution didn't work.

It probably works best for one customer only, unless I've missed something in my logic?

Issues:

1. applies conditional formatting correctly to the 1st customer only.

2. doesn't work in couple with Row Rules (bold total rows)

Alteryx Coomunity,

Can you please help to figure out how to make the attached workflow work for all customers and how to use both column and row rules:

a) row rule to bold 4 totals at the end of the table

b) column rules to highlight Column Value in yellow where it's equal or less than the value indicated in "..2STDDEV_BELOW"

Any suggestions would be greatly appriciated!

ALTRX_CNDTNL_FORMATING.yxmd

FrederikE · Answer

Hey @ValeriaK,

Yes this is possible. You would need to do the calulation for the value you want to compare to and then Append it to your Dataset.

E.g. append the "Order_Count_2STDEV_BELOW" as its own column to the dataset

And then use a "Row Rule" in the Table Tool to specify the condition you want to compare to.

E.g. [Customer 1] > [Order_Count_2STDEV_BELOW]

And then choose "Background Color" Yellow.

New Workflow9.yxmd