Distribution of case and controls in different age groups - Plot & table

[mantubiradar19]

I have a dataset containing binary variable DIAGNOSIS (0 & 1 for control and case) and the range of AGE is from 20 ~ 80. I'm interested to see the distribution (# of cases & controls) in various age groups with an interval of 10 years. (20~30, 30~40, 50~60, 60~70, etc). 

Please suggest to me how to obtain suitable tables and plots to visualize my data. 

PS: I have attached an example 

Thanks in advance

[PetriRoine]

Hello @mantubiradar19 

The following instructions are based on the assumptions that the data is aligned like this:

Age	Diagnosis
37	0
76	1
29	0
…	…

Steps taken

1. Create Age group category: 
   Use the Custom category feature to create age buckets.
   
2. Create Cases measure:
   Use the New Calculated Item feature to calculate number cases.
   

   IF ( 'Diagnosis'n = 1 )
   RETURN 1
   ELSE 0

3. Create Controls measure:
   Use the New Calculated Item feature to calculate number of controls.
   

   IF ( 'Diagnosis'n = 0 )
   RETURN 1
   ELSE 0

4. Create Total measure:
   Use the New Calculated Item feature to calculate number of cases + controls.
   

   'Cases'n + 'Controls'n

5. Create Cases %, Controls %, and Total %
   Use the New Calculated item feature to calculate three new aggregated measures.
   Cases %
   

   Sum [_ByGroup_] ('Cases'n) / Sum [_ForAll_] ('Cases'n)

   Controls %
   

   Sum [_ByGroup_] ('Controls'n) / Sum [_ForAll_] ('Controls'n)

   Total %
   

   Sum [_ByGroup_] ('Total'n) / Sum [_ForAll_] ('Total'n)

   
   
6. Utilize Crosstab object and assign roles as below
   
   

I hope this helps.

Best regards,

Petri

[mantubiradar19]

Thank you ~ Petri