Built something you're proud of? Tell the story. A quick G2 review of App Engine or Build Agent helps other developers see what's possible on ServiceNow. Share your experience.

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
Giga 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