We are celebrating the 10-year anniversary of the Alteryx Community! Learn more and join in on the fun here.
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

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

ValeriaK
7 - Meteor

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:

vkupreychuk_0-1685543206835.png

Thank you in advance!

3 REPLIES 3
FrederikE
13 - Pulsar

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. 

 

 

FrederikE_0-1685545148640.png

 

ValeriaK
7 - Meteor

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!

 

ValeriaK
7 - Meteor

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

 

Labels
Top Solution Authors