Setup us an audit file using:
All questions are answered by selecting either "Yes" or "No"
All audits are one of three audit types, Hole Watch, Fire Watch, Bottle Watch
There are 36 questions in total with each having an audit type field grouping the questions for audit type.
I'm trying to build a couple of charts to help build a dashboard.
1st, I tried to develop a stacked column chart that shows how many yes's and no's were found in a timeframe, the last month, for each audit type
And 2nd, I tried to build a chart that showed how many times each question was answered "Yes" or No"
Any ideas out there?