Skip to Content (Press Enter)
2020-12-07 22-53-13
Tiago Fernandes
67Views
4Comments
Solved
Age range - Column Charts
Question
Charts

Hello,

I am creating a column chart do display information about age range regarding a group of people.

On my query I've aleady created  "Round(DiffDays(Person.DateOfBirth,CurrDate())/365)" to get me ta age of each one of them, but now I'm strugling to group them by age range.

I've attached a picture to show the example of what I wan't.


Thank you,


Tiago Fernandes


Capturadeecr20210517111924.jpg
0
0
17 May 2021
Copy Link
2021-05-18 02-27-17
Manish Gupta
Champion
Solution

Hii Tiago 

What challenge are you facing? Please try with following the below steps - 

  1. As mentioned in your question it seems the Age Column of your aggregate is having AGE not the AGE Range.
  2. So, you can Groupby the age easily but for Age Range you can do something else -
    1. Create one more column with the Category - A,B,C,D...
    2. Give the formula If Age is >18 AND <30 = Category A
    3. Follow this and give all of them an Autoassign Category
    4. Then GroupBy the Category. 

I hope it is clear and will be helpful 

0
0
17 May 2021
Copy Link
2021-04-17 09-53-48
José Gonçalves

Hi Tiago,

in the aggregate create a new column/function per age range as a boolean. Then group and count the results.

0
0
17 May 2021
Copy Link
2020-12-07 22-53-13
Tiago Fernandes

Hello Manish,

Problem solved!

Thanks for your help!

1
0
17 May 2021
Copy Link
2021-05-18 02-27-17
Manish Gupta
Champion

Welcome Tiago :) 

0
0
17 May 2021
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.