Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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