Forum Discussion

jthomson's avatar
jthomson
Solution Sage
8 years ago

Conditional formatting - data bars based on other field?

 

 

Data set is simple - two columns, one showing a category of job, the other saying yes or no depending on whether the job has been settled. Here I've got two measures - one counting the number of jobs that have been settled, the second showing the number that have been settled as a percentage of all jobs.

 

Is it possible to conditionally format the settled column as a data bar using the values of settled%? Both of these columns are formatted using the values of settled%, but if I pick data bars on the settled column it doesn't allow me to change the field it uses to format, I can only use background/font colours, and I'd like the style of the second column. Any ideas? Cheers