Breakdown relation on a field related to a glide list
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-20-2018 11:51 AM
I am trying to add a breakdown to an incident based indicator. The breakdown source is built on the table that contains the values and now I need to map this breakdown to the incident table.
I'm going to attempt to explain my requirement:
- Indicator is built on the incident table
- Breakdown source is on something called the business capability category.
- The mapping I have SO FAR is cmdb_ci.ref_cmdb_ci_appl.u_business_cababilty.
- u_business_capability is a glide list and I need to get to the next level of u_category_name.
Since I can't dot walk from the glide list, would I need a PA script? I don't even know exactly how to begin with this? Can someone provide links, steps, how to's on this?
- Labels:
-
Dashboard
-
Performance Analytics
-
Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-20-2018 12:02 PM
I use GlideLists for displaying data, but when you use them, assume they are not reportable. It complicates virtually everything you want to do with the field.
For a breakdown, you should be able to use the list field itself (with no script) but I'm not sure how you will get a breakdown relation to work as they are not scriptable and they require a specific field (sys_id) to work.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎02-20-2018 12:09 PM
Unfortunately, I don't have the option to use any other field. This is the only field defined on the application table related to the information I need.