The dashboard I'd like to show has red/yellow/green values in about 10 categories. All of the examples I've seen show aggregation of numeric data like sales, so the only thing I can come up with to show non-numeric data is a pivot table to show dashboard across programs and people, e.g.:
Is there a better way to show this type of data? I'd like to be able to click through any of the table values to see trends across categories, e.g., what programs are red in Schedule and also yellow in Technical, or what is the trend in colors for one program over time, etc.