AGE ANALYSIS

[renuka_sasikumar]

Hi,

I have a DOB Field & a LinkCommonDate in which I want to show age analysis

Which means which are the (Count()Employee) employees following in the age buckets

AGE ANALYSIS		%     | VALUE
VERTICAL	18-25	26-35	36-45	46-55	56-60	> 60
X
Y
Z
All

Thanks & Regards,

Renuka S

[alexandros17]

What is the problem?

[#3]

Here we have to calculate the age of every employed with help of Current date - DOB and store in the other field.

Then we also i have make a Age_Bucket field which will have records

18-25

26-35

36-45

46-55

56-60

> 60

Then we can show age analysis in the pivot chart as you wish to do so.

[mdmukramali]

Dear Renuka,

Kindly find the attache sample file.

I hope it will full fill your requirement.

        Replace(Class(Age(today(), DOB),10),'<= x <','-') as AgeRange; 

       //Dual('Age ('&Replace(Class(Age(today(), DOB),10),'<= x <','-')&')',Class(Age(today(), DOB),10)) as AgeRange;

Thanks,

Mukram

[renuka_sasikumar]

Hi,

There is no any sample file attached

Thanks & Regards,

Renuka S

[renuka_sasikumar]

Hi,

i have created the buckets in the front end. but it is not working without selection based.

[mdmukramali]

Dear,

Find the attached file.

Thanks

Mukram

[#8]

Is this what you wanted in the results?

[vikasmahajan]

Hii

Renuka  if you are using sql backend then create age buckets in script using following scripts

      'Age_Bucket' =

                      CASE

                          WHEN DATEDIFF(day, d_date_of_birth, GETDATE())/365  < 25 or DATEDIFF(day, d_date_of_birth, GETDATE())/365 IS NULL  THEN '< 25 Yr'

                          WHEN DATEDIFF(day, d_date_of_birth, GETDATE())/365 >=25 and DATEDIFF(day, d_date_of_birth, GETDATE())/365 <35  THEN '25-35 Yrs'

                          WHEN DATEDIFF(day, d_date_of_birth, GETDATE())/365 >=35 and DATEDIFF(day, d_date_of_birth, GETDATE())/365 <45  THEN '35-40 Yrs'

                          WHEN DATEDIFF(day, d_date_of_birth, GETDATE())/365 >=45 and DATEDIFF(day, d_date_of_birth, GETDATE())/365 <55 THEN '40-55 Yrs'

                          WHEN DATEDIFF(day, d_date_of_birth, GETDATE())/365 >=55  THEN 'Above 55 Yrs+'

                      END

and then use this Age_Bucket Field in chart

I have implemented same logic . pfa sample chart image also.

Vikas