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?
⋅ 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
⋅ 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.
⋅ 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
