I have a form where the user should answer with a checkbox and therefore the answer will be TRUE or FALSE in the database.
What I wanna do is following:
I have a questionnaire.
For each question there is three parts (a, b, c) e.g. 1a, 1b, 1c.
1a, 1b, 1c
2a, 2b, 2c
3a, 3b, 3c
In the database I wanna have a property “Question 1”. If 1a or 1b or 1c = TRUE (marked) I want the property “Question 1” to be true. Is it possible? How?
I wanna show a bar chart with Question 1, Question 2 etc. where
X-axis = Question number
Y-axis = Number of people (rows in the database) that have “Question 1” as true, “Question 2” as true etc. I dont wanna show 1a, 1b, 1c in the graph, only 1, 2, 3 etc. where 1 is TRUE if any of 1a, 1b, 1c is true.
First I was thinking if the checkbox was marked (=TRUE) I could make an automatic field that says Question 1 = 1 (number format) and then I could show it in a graph. But don´t know how to solve it.
Hope anyone can help me.