Thank you. I had been using his blog to inform how I am transforming most of my questions. I am still trying to think through question 4, which has 3 parts that are all related.
I need to show how many cases for each type of "misconduct", how they are generally reported, and to whom. So, I have to show combinations of how an individual reported said type of misconduct and to whom by the type of misconduct.
Right now I've transformed this question like this and each section gets a unique id. Not sure this works though for what I'd like to do.
So, maybe my question is more like:
1) How might I go about visualizing this and relating these by type of misconduct? I was thinking a tree map for observations (20a), then maybe a heat map with to whom (20c) and how it's reported (20b). But, the heat map would need to be filterable by the type of observation. I have not committed to any format, just trying to think through it and keep it as simple as possible.
2) Are there better ways to transform or label/adjust my data? Or is this the best way to move forward?