How to make Bucket Columns (Grouped Columns)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-30-2025 09:55 PM
I want to visualize the Duration of sc_task.
To visualize the elapsed day after sc_task created owned by the assingnated person as follows.
・0~2days
・3~7 days
・More than 7 days
When create the report using a pivot table format
・Row : Assign to
・Column : Duration
a large number of columns (Duration) will be created, each of which differs by a second.
For example, Salesforce allows us to define a “Bucket column,” which allows us to grouping data into three columns with threshold values as set above.
Is it possible to implement such a feature without using script for general user?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-31-2025 02:11 AM
Not in a pivot table. Duration is time based field and it will create a column for every value.
Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark