Conditional formatting per bar category

[Simon]

I'm trying to implement the following. A barchart with as the categroy the different departments and as the value the amount of mistakes that they have made. The mistakes are linked to employees and not every department has the same amount of employees. I want to create a graph that colors the bar green if the department has less than 10 mistakes per employee total and red if it has more. I have it implemented in Power BI, but I want to transfer the report to Spotfire. I will attach a snipping about the graph without department names. The black line indicates the threshold.

[David Boot-Olazabal]

Hi Simon,

You could start with a Bar chart and add color coding rules:

In the example above, I've added two color coding rules, based upon the threshold of 10 failures.

Kind regards,

David

[Simon]

Hi David,

This would not give the correct view since there are multiple employees per department. The goal is to turn red if the number of issues is greater than 10 * number of employees per department.

So if Finance had 2 employees in its department, it would still show as green.

 

[Simon]

I have found the solution. By adjusting my color by to the formula I got it to work.

[David Boot-Olazabal]

Hi Simon,

Nice to hear you got it solved.
Could you share your solution, so anyone else having the same issue can benefit of your solution?

Kind regards,

David