Raw Age is a number of days, which reads badly on a dashboard. Bucketing gives you bands.
- Add the Age column
Open your Cases report in the Lightning report builder and drag Age from the field panel into Columns.
- Bucket the column
Use the Age column menu and pick Bucket This Column, or choose Add Bucket Column in the Columns section.
- Set the range breakpoints
Enter each upper bound, lowest first. Two, seven and thirty produce four bands.
- Group by the bucket
Drag the bucket into Group Rows. Unlike Business Hours Age, a bucket column sorts, filters and groups like any other column.
Key options
Report bucket columnremember
Fastest route. Lives in one report and needs no object change.
Custom formula fieldremember
Slower to build, and it costs a custom field, but you build it once.
Gotchas
- Business Hours Age cannot be bucketed or filtered, so SLA bands have to come from plain Age.
- A bucket column lives in one report. Three dashboards needing the same bands is a formula field's job.