2 Replies Latest reply on Dec 31, 2019 3:18 PM by Ken Flerlage

# How can I colour the bars based on whether the SLA percent of total has been met or not?

Hi, I am new to Tableau and would like to create a sheet that indicates whether an SLA has been met. The SLA is calculated as: IF[Business Minutes Elapsed] <= [SLA Mins] then "Met" else "Not Met" END

The option I am using is below.

In this option, I would like to colour the bars based on whether the SLA has been met. For example, if the SLA has been met >= 60% of the total then I would like the bar to be coloured green otherwise I would like the bar to be coloured Red.

In the rows I have Category, Item being Tracked and SLA where SLA is the calculated field above.

In the columns I have a table calculation which ‘For each Category and Item Being Tracked, computes the Percent of Total by SLA, pane down‘.

Note: I only want to display the SLA ‘Met’ row as the ‘Not Met’ is the complementary value and is not needed (e.g. if Met is 66.67% then I do not want to display the ‘Not Met’ value of 33.33% as this is not needed). To do this I am using an Index field and a calculated field ‘SLA Met Index is 1’ which is used in the filter.

I have added a Reference Line at 60%.

I have added a table calculation on Colour but this does not give the result I want and I cannot see any options to change this. I would like the second bar to be green (> 60%) and the other bars to be red (< 60%).

I will ultimately hide the SLA column that shows the value Met

My question is: how can I colour the bars based on whether the SLA percent of total has been met or not?

If this is not possible, are there any other alternatives that would achieve the same result? Any suggestions are much appreciated.

I am on Tableau 10.5.

The workbook I am using is attached

• ###### 1. Re: How can I colour the bars based on whether the SLA percent of total has been met or not?

I have solved my problem. I am no longer using table calculations for the Percent of Total but using calculated fields which I have more control over the colours. I am using stacked bars (need this as if I only display one item then if this item has no data then no data is displayed). The result now looks like

The workbook is attached

1 of 1 people found this helpful
• ###### 2. Re: How can I colour the bars based on whether the SLA percent of total has been met or not?

OK, so you no longer need any assistance?