Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
What is the problem?
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.
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
Hi,
There is no any sample file attached
Thanks & Regards,
Renuka S
Hi,
i have created the buckets in the front end. but it is not working without selection based.
Dear,
Find the attached file.
Thanks
Mukram
Is this what you wanted in the results?
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