CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviReport (Moderator: Dave Greenberg) »
  • How many people choose x option in my custom data?
Pages: [1]

Author Topic: How many people choose x option in my custom data?  (Read 885 times)

russmartin

  • I’m new here
  • *
  • Posts: 12
  • Karma: 0
  • CiviCRM version: 4.0.2
  • CMS version: Drupal 7.2
  • MySQL version: 5.0.52
  • PHP version: 5.0.59
How many people choose x option in my custom data?
April 12, 2012, 09:36:15 am
I have a custom data set with a number of questions including a checkbox question called, "I would like a free magazine about X..." where contacts can choose between 0-5 options to request a free magazine about one or more of the five topics.

I would like to create a report that tells me how many contacts requested each type of magazine.

For example:
X - 4448
Y - 4069
Z - 4937
A - 6683
B - 4037

Currently, the only way I know how to get this data is by doing a search and selecting the appropriate check box for magazine x, y, z etc... Obviously this is somewhat tedious and not easily repeatable on demand.

Is there a way I can create a report for this out of the box, (without coding), or is coding required?

ddunn

  • I’m new here
  • *
  • Posts: 24
  • Karma: 0
  • CiviCRM version: 4
  • CMS version: Drupal
  • MySQL version: 5.0.7-dev
  • PHP version: 5.3.4
Re: How many people choose x option in my custom data?
April 27, 2012, 02:40:46 am
I'd be interested in a solution to this also! Thanks russmartin for posting

ddunn

  • I’m new here
  • *
  • Posts: 24
  • Karma: 0
  • CiviCRM version: 4
  • CMS version: Drupal
  • MySQL version: 5.0.7-dev
  • PHP version: 5.3.4
Re: How many people choose x option in my custom data?
April 27, 2012, 02:43:47 am
By the way, russmartin, you might be interested in this solution by darkchild for sorting by your custom fields - it at least would make it easier for you to visually see how many (roughly) people have selected certain options, if you sort by that field.

http://forum.civicrm.org/index.php/topic,24430.0.html

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: How many people choose x option in my custom data?
April 28, 2012, 05:24:49 pm
Quote from: russmartin on April 12, 2012, 09:36:15 am
Is there a way I can create a report for this out of the box, (without coding), or is coding required?

AFAIK it would have to be coded. But it could be done low tech in SQL and would be a fairly simple query. Very simple actually.
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviReport (Moderator: Dave Greenberg) »
  • How many people choose x option in my custom data?

This forum was archived on 2017-11-26.