1 of 1 people found this helpful
If you are building a dashboard, you can create individual sheets for each measure, color each measure accordingly on their individual sheet, and then combine them into a row on your dashboard.
The other solution I can think of depends on the structure of your table. If your underlying table looks like the example above, then this won't work. Otherwise, make sure your measures are all in one single column, and their corresponding "labels" are in a second column. (Tableau likes data tables that are longer rather than wider -- or so I've been told.) That way you can create a series of calculated fields based off of the column with the measure labels.
I've thought about building each 'box' as its own worksheet, but I figure there has to be a way to get a calculated field to work for just one field (and not the others). Right now, if I write a calc field to turn green if inventory is within a range, but then it turns all of the fields green. Do you know how to create a calc field to ONLY turn one? Or to exclude the other data points from the field?
Thanks for taking the time to help think through this.