Help with Chart

[Anonymous]

Hi All

I am tasked with creating a Bar chart with age range

so Dimensions are days 0-20, 21-40, 41-60 etc

And it counts how many tickets are open

My question is how do i go about this?

[sunny_talwar]

Use a calculated Dimension using Class function and a simple Count function for counting field in each bucket. Would you be able to to share a small sample to help you better?

[erivera10]

Hi,

Use master calendar, that's the best practice.

Best regards,

Erivera10‌

[swuehl]

Have a look at

Recipe for a Histogram

Buckets‌

You can probably use something like

=Class( AgeField, 20)

as calculated dimension and

=Count( AgeField)

as expression.

[sunny_talwar · Accepted solution]

See if the attach helps

[Anonymous]

Sunny Thanks for your help!

Any ideas how to change the Labels on the bottom?

so it says 0-20, 21-40 etc?

Currently saus 0>x=20... etc