Group By Age on a Bar Chart

[qlikfresh]

Hi Guys

Just wondering what is the best way to group by age in a bar chart and display the total number of results within that bracket, example:

I want to sum the results that are 0-1 days old, 2-4 days old, 5-7 days old etc on a bar chart

Any help would be great, thank you 😄

[tm_burgers]

Can you use the Data Manager to create Buckets? or in the Load editor you can recreate a bucketting formula to create a new Dimension?

ie. - if(Age >=0 and Age <2, '0-1 days old, if(Age >1 and <5, '2-4 days old'   ...etc

Otherwise, there are a few options for your bar chart:

1. One Dimension and Three Measures - each measure a set analysis like count({< Age = {">=0<2"}>} Age) 

2. One ValueList Dimension, and One Measure that defines all measures.