Answers.Body: <p>You can use SUM function in fields to get the total number per record, but you will need to group by record id</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-03-22T02:39:11.713Z
Answers.Text: Thanks, full_group_by needed to be turned off from mySQL as well.
Answers.UserDisplayName: Tapash
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2024-03-20T10:36:49.913Z
Answers.LastActivityDate: 2024-03-20T10:36:49.913Z
Answers.UserDisplayName: Pradeep Nayak
Body: <p>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.</p>
  <p>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.</p>
  <p>Has anyone tried this before? Any help would be appreciated.</p>
  <p>Thanks</p>
  
Tags: <custom-fields><profile><reports><searchkit>
Title: How to get a feedback statistic using civicrm custom field?
ThreadText: # How to get a feedback statistic using civicrm custom field?
  
  (Asked by: username_0 on 2024-03-20)
  
  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.
  
  Thanks
  
  **Tags:** custom-fields, profile, reports, searchkit
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_1 on 2024-03-20. Score: 2 | Accepted answer
  
  You can use SUM function in fields to get the total number per record, but you will need to group by record id
  
  > **Comments:**
  > **username_0**: Thanks, full_group_by needed to be turned off from mySQL as well.  
  
  ---
  
  