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 Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Average Age
Pages: [1]

Author Topic: Average Age  (Read 893 times)

FastPhil

  • I’m new here
  • *
  • Posts: 23
  • Karma: 1
  • CiviCRM version: 4.04
  • CMS version: Drual 7
  • MySQL version: 5.154
  • PHP version: 5.3.5
Average Age
January 12, 2012, 01:51:10 pm
I would like to figure the average age of my members.  I have not figured out how to do that and I was thinking export to a spreadsheet and then figure it but it appears that you can not export the age you have to export the birthdate and then figure the age is that Correct?

Kurund Jalmi

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4169
  • Karma: 128
    • CiviCRM
  • CiviCRM version: 4.x, future
  • CMS version: Drupal 7, Joomla 3.x
  • MySQL version: 5.5.x
  • PHP version: 5.4.x
Re: Average Age
January 12, 2012, 11:06:01 pm
Quote
I have not figured out how to do that and I was thinking export to a spreadsheet and then figure it but it appears that you can not export the age you have to export the birthdate and then figure the age is that Correct?
Yes, that would be the approach.

Kurund
Found this reply helpful? Support CiviCRM

FastPhil

  • I’m new here
  • *
  • Posts: 23
  • Karma: 1
  • CiviCRM version: 4.04
  • CMS version: Drual 7
  • MySQL version: 5.154
  • PHP version: 5.3.5
Re: Average Age
January 13, 2012, 05:10:37 am
Well I guess I will have to take notes over the next few months as we become more accustomed to Civi and its use and then propose some added features and try to back it with some resources.  Thank you for your help.

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: Average Age
January 14, 2012, 01:30:34 pm
Quote from: FastPhil on January 12, 2012, 01:51:10 pm
I would like to figure the average age of my members.  I have not figured out how to do that and I was thinking export to a spreadsheet and then figure it but it appears that you can not export the age you have to export the birthdate and then figure the age is that Correct?

You could also compute the average age of your members with one MySQL query actually. You would need to know a bit about SQL to write it, but once it's done, it can be re-used. :)
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 Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Average Age

This forum was archived on 2017-11-26.