1 of 1 people found this helpful
Well, you can get the reference lines for each measure by switching the reference line to calculate "Per Cell" as opposed to "Per Pane". However, you are going to run into issues specifying different static thresholds for each measure - where will that information be stored? Tableau needs a way to associate a measure with a threshold, and because you have structured your data in a wide format (separate fields for each measure), you can't just add a new field with your threshold values.
Unfortunately the cleanest solution and best practice would be to restructure your data into a long format (one field designating the measure, another assigning measure values).
I am not sure on how to go about restructuring the source sheet's data to have Avg Talk, Avg Hold and Avg Wrap grouped in one category. Above screenshot is what I have done in my source sheet but it didn't work. Turns out my Average Time didn't become my main string category, instead Tableau takes Average time = Avg Talk in this case.
Opps nvm, i think the only way for those 3 parameters to be part of the subcategory is to run the data in rows of my source sheet instead of column...