Bar Chart Question

Question

I feel like this should be a simple task, but for some reason I am just not getting it.

I have an audit form with 20 questions. Each question can be pass/fail. I want to set up a bar chart where each bar is the total number of fails for all audits. So if on four of the audits there is a 'fail' for question 1, then the bar would show 4. And when I drilldown, it will show me those 4 specific audits.

My closest attempt is setting my x axis to the year of the audit, then adding all 20 questions (fail checkbox) to my y axis. This gives me almost my desired result. The chart looks right, but the drill down shows me all audits in that particular year (versus only the 4 audits with the fail).

I can't seem to wrap my head around how I should set this up.

------------------------------
Mike Tamoush
------------------------------

MarkShnierYou · Answer

Your Analysis would be way more flexible if you designed the survey with a header record and then 20 children with the 20 questions. Then you could slice and dice the children on charts anyway you want. 20 children would automatically be imported when the user created a new Audit.

At this point if you wanted beautiful analysis then you would have to create the children after the fact using Automations or Pipelines create 20 children corresponding to the 20 answers on the Parent audit.

------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------

Sign up

Login to the community