Hi there, I want to show employee turnover by department in the form of a bar chart (yellow tab in attached workbook). I'd like to also include a reference line that shows the overall company turnover for the selected year. However, I can't tell if this is possible. Right now the line I have refers to the average turnover of the three departments, but this obviously isn't the same as the company turnover for the year (red tab). I've found some content online about reference lines, but nothing in the context of employee turnover.
Is what I'm after even possible? Thanks!
I believe reference lines will only generate output based on the level of detail included in the view itself (Department in this case). I didn't see anything in the Tableau documentation on reference lines to have them leverage row-level data instead. Answering with a couple of workarounds I might use instead:
The first sticks with a single year and shows columns for each Department (adding a Row Total produces the same "average" as the reference line) next to the overall value calculated at the row-level in a separate view.
The second way I would do this is if I wanted to show the row-level overall turnover trend as a reference point for the departments is to duplicate the turnover measure and use a dual-synchronized axis - once with Departments on the color mark and once without to show the overall turnover.
