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",
}
}
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