In the previous article we learnt about analysing form results by entity associations like clients, projects etc. Also by “assign on submit” and by form submissions (who submitted the form - fieldworker or office employee).
This article talks about how you pull questions and answers into the form result report.
In order to do so, you need to use, Question from Form Results Detail, Depending on the Question Type you select.
If your question type is
Number then you choose “Answer Number“
Worker then you choose “Full Name“ or any other attribute from “Answer Fieldworker Entity“
Equipment/Asset then you choose any other attribute from “Answer Equipment/Asset Entity“
Everything else you choose “Answer Text“
If you need to aggregate(sum) the answers which were of the question type number, you could you the measure “Sum of Results Answer Number“
Multiple times specially for Payroll Reports we need to create a report in a particular format., where we need to have the answers sitting underneath the questions.
In those case, you simply need to
Pull the Questions in.
Pivot the Questions
Pull the “Results Answers“ from Form Result Details Answers.