Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 😄
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.