Answers.Body: <p>In case anybody searching for this:
  We've developed a tiny extension for this purpose and published under
  <a href="https://github.com/kompetenzz/net.kompetenzz.freco" rel="nofollow noreferrer">https://github.com/kompetenzz/net.kompetenzz.freco</a>.
  This extension provides API4 and UI to compute frequency distribution across a set of custom fields.</p>
  
Answers.ContentLicense: CC BY-SA 4.0
Answers.CreationDate: 2023-01-06T11:22:19.107Z
Answers.LastActivityDate: 2023-01-06T11:22:19.107Z
Answers.UserDisplayName: nielo
Body: <p>we have set up a tiny survey with a bunch of custom fields with data type int and a radio controlled option set</p>
  <pre><code>Value | Label
  -------------
   -1   |  No
    0   |  Unknown
    1   |  Yes
  </code></pre>
  <p>attached to activities of a specific type.</p>
  <p>We're looking for a way to create a statistical evaluation called frequency distributions. The result would sum up the occurences of every option value for a set of fields and display it by label.</p>
  <p><a href="https://en.wikipedia.org/wiki/Frequency_(statistics)#Frequency_distribution_table" rel="nofollow noreferrer">https://en.wikipedia.org/wiki/Frequency_(statistics)#Frequency_distribution_table</a></p>
  <p>I'm not a native english speaker but from my understanding of civicrm docs and code there's is no report template (neither in core nor in ExtendedReports or Report+) and no dataprocessor source/aggeragation field for this popose.</p>
  <p>How/where would you implement it?</p>
  <p>I thought about a dataprocessor custom group source which serves the data and a new aggregation type. But dataprocessor seems not to allow injecting new source classes from outside it's very own Factory class. And a customized fork maintained by me is'nt what want.</p>
  <p>I know I can use drupal 7's view aggregation but I would prefer extending civicrm.</p>
  
Tags: <extension><civireport><core>
Title: Frequency distribution for radio custom fields / survey / statistics / report
ThreadText: # Frequency distribution for radio custom fields / survey / statistics / report
  
  (Asked by: username_0 on 2022-12-16)
  
  we have set up a tiny survey with a bunch of custom fields with data type int and a radio controlled option set
  
  ```
  Value | Label
  -------------
   -1   |  No
    0   |  Unknown
    1   |  Yes
  
  ```
  
  attached to activities of a specific type.
  
  We're looking for a way to create a statistical evaluation called frequency distributions. The result would sum up the occurences of every option value for a set of fields and display it by label.
  
  <https://en.wikipedia.org/wiki/Frequency_(statistics)#Frequency_distribution_table>
  
  I'm not a native english speaker but from my understanding of civicrm docs and code there's is no report template (neither in core nor in ExtendedReports or Report+) and no dataprocessor source/aggeragation field for this popose.
  
  How/where would you implement it?
  
  I thought about a dataprocessor custom group source which serves the data and a new aggregation type. But dataprocessor seems not to allow injecting new source classes from outside it's very own Factory class. And a customized fork maintained by me is'nt what want.
  
  I know I can use drupal 7's view aggregation but I would prefer extending civicrm.
  
  **Tags:** extension, civireport, core
  
  
  ---
  
  ## 1 answers
  
  ### Answer by username_0 on 2023-01-06. Score: 1 | Accepted answer
  
  In case anybody searching for this:
  We've developed a tiny extension for this purpose and published under
  <https://github.com/kompetenzz/net.kompetenzz.freco>.
  This extension provides API4 and UI to compute frequency distribution across a set of custom fields.
  
  
  ---
  
  