Despite the COVID-19 outbreak, our team continues operating at full speed. We are always here to support and answer all your questions.

Feel free to reach out by filling this quick form.

Fill the form
Get Free Trial

How can I conditionally format a column based on row value

Answered
Ravi asked on November 13, 2020

In here https://jsfiddle.net/ravimarch7/o9x71zcw/5/
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

Public
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: https://jsfiddle.net/flexmonster/xakozLrw/
 
Please let us know if this helps.
 
Regards,
Mykhailo

Public
Ravi November 16, 2020

Hi Mykhailo Halaida, 

Thanks for your response.

In https://jsfiddle.net/flexmonster/xakozLrw/ 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.

Public
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.
 
Regards,
Mykhailo

Please login or Register to Submit Answer