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 to measure a column and format the color of another column

Answered
Ranjith 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”,
}
}
 

1 answer

Public
Illia Yatsyshyn Illia Yatsyshyn Flexmonster 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

Please login or Register to Submit Answer