Get Free Trial

How can I conditionally format a column based on row value

Ravi asked on November 13, 2020

In here
We need to create a conditional format for “Score” measure. and the Condition should be based on “Company” and “Calc”. This Feature is Available in tableau. Can we do this in our product?

3 answers

Mykhailo Halaida Mykhailo Halaida Flexmonster November 13, 2020

Hi Ravi,
Thank you for posting your question.
We would like to confirm it is possible to use other fields’ values in your formulas – it seems like you’ve already done that by using the value of “Results” in conditional format for the “Score” field.
Please see a slightly modified example illustrating the usage of the required fields in conditional formatting:
Please let us know if this helps.

Ravi November 16, 2020

Hi Mykhailo Halaida, 

Thanks for your response.

In this example you are using the count aggregation of Company  field, for the formula of conditional formatting.

But we need to use the value of the Company field, like
“formula”: “‘Calc’ == 1 AND  ‘Company’ == ‘Mantro’

please share the example for this.

Mykhailo Halaida Mykhailo Halaida Flexmonster November 16, 2020

Hi Ravi,
Thank you for your response.
Currently, Flexmonster does not provide a way to apply conditional formatting based on string values.
In case this functionality is important to you, we would suggest considering the customizeCell() API call to implement your own cell customization logic.
We hope this helps.

Please login or Register to Submit Answer