AnsweredAssumed Answered

Charting Calculation

Question asked by CalebTurner on Jun 4, 2014
Latest reply on Jun 5, 2014 by philmodjunk

Title

Charting Calculation

Post

     Setup us an audit file using:

     Audits------<Audit_Question>-------<Questions>-----Audit_Types

     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?

Outcomes