How to make Bucket Columns (Grouped Columns)

Nicholas KK
Tera Contributor

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?

1 REPLY 1

Mark Manders
Mega Patron

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