Breakdown Source Field

Edwin Fuller
Tera Guru

Is there a reason why the "Field" is restricted to reference fields only when creating new Breakdowns Sources?

find_real_file.png

1 ACCEPTED SOLUTION

Adam Stout
ServiceNow Employee
ServiceNow Employee

Breakdowns are stored by sys_id so they have to have one.  References, of course, have a sys_id.  If you need to breakdown by a choice, you breakdown source will be sys_choice (you should find several examples out of the box).  For numbers, you'll want to look at buckets (which then have a source on pa_buckets).  You can also use manual breakdowns but I highly discourage this as it is often masking a data structure problem.

View solution in original post

2 REPLIES 2

Michael Fry1
Kilo Patron

It should be restricted to fields that have choices so you can breakdown the sources by the different choices.

Adam Stout
ServiceNow Employee
ServiceNow Employee

Breakdowns are stored by sys_id so they have to have one.  References, of course, have a sys_id.  If you need to breakdown by a choice, you breakdown source will be sys_choice (you should find several examples out of the box).  For numbers, you'll want to look at buckets (which then have a source on pa_buckets).  You can also use manual breakdowns but I highly discourage this as it is often masking a data structure problem.