asked on June 16, 2020
How to conditional format one one column and format the color of another column
Right now i can only measure the value of the same column and format the same column I want extend the format to other columns also
ex)
"conditions": [{
"formula": "#value < 0",
"measure" : "Diff",
"format": {
"color": "red",
}
}
⋅ June 17, 2020
Hello, Ranjith,
Thank you for your question.
Conditional formatting of the column can be based on the values of another column through specifying its aggregation and uniqueName.
For example, the following code snippet demonstrates the way to format the "Score" hierarchy basing on the "Results" column.
"conditions": [{
"formula": "sum('Results') > 10",
"measure": "Score",
"format": {
...
}
}]
Please see an example we have prepared for you.
Our team hopes it helps.
Do not hesitate to contact us in case additional questions appear.
Kind regards,
Illia