I have created a set of custom fields with 5 questions. It has 5 radio button rating 1 to 5. Then the questions were used in a profile to receive feedback from customers for the services they are receiving.

I am struggling to get a meaningful report/statistics for all the questions individually or collectively. I have tried searchkit but cant get the count of total of each question.

Has anyone tried this before? Any help would be appreciated.


1 Answer 1


You can use SUM function in fields to get the total number per record, but you will need to group by record id

  • Thanks, full_group_by needed to be turned off from mySQL as well.
    – Tapash
    Commented Mar 22 at 2:39

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.