Hello. I'm new-ish to both Tableau and to this forum. I'm looking for the best way to display a specific set of data but first I need to explain a little background about what I'm attempting to do.
I'm in the process of building a Management of Change (MOC) system for my employer. As a company we have 5 different "types" (think categories) of changes:
- Chemical/Hazardous Material
Our MOC program has approx. 18 checklists that are used to evaluate the impacts of each one of these changes; and each of these checklists are discipline-based (think one for accounting, one for engineering, one for HR, etc.). I sent out a spreadsheet (similar to the one I attached) to all of my stakeholders and asked for their feedback on which checklists should be "default" for each type of change. My goal is to build a "template" for each category of change so that our MOC software will automatically select the proper evaluation checklists once the user has picked the category of change.
When I sent out the spreadsheet to the stakeholders with the current default checklists "X'd"...I asked them to either add a green X where they think a certain checklist should be added to a template or to put a strikethrough red X where they think a checklist should be taken away from a template. The data I wish to display is where disagreements exists between Stakeholders and maybe even "how much" disagreement. My thought process is that in areas where most or all of the stakeholders agree to the current default, we probably got it right; but, where there exists some "threshold" of disagreement, we need to have further discussions.
Anyone have any ideas about some creative and/or best ways to display this data? Hopefully I've given enough information but if not, please feel free to ask. Thanks in advance for your help.