PA- Column added to Incident table not showing as element for breakdown source

[jlaps]

Hello community!

In developing indicators and breakdowns for my IT department, I am having trouble with a column IT added to the INC table- it is not selectable in the "SELECT ELEMENT FROM THE TREE" pop-out after choosing the INCident table in the BREAKDOWN SOURCES module. I can grab all the other things I needed from there, but a column created and added to the table I cannot. From comparing the columns on the table, all the ones that are selectable as ELEMENTS are REFERENCE fields, not columns in and of themselves. I am not a DB expert, so I think I am missing some basic knowledge and have not been able to figure it out.

For a new column created on the incident table, that has its own choice list and does not reference anyplace else, how can I use that column as a breakdown source in PA?

If I go into the REPORTING module, I can easily group by this field and pretty much see what I want to see (this is a wrap-up code selected on INC resolution, similar to a CI at resolution, but not a CI). However, if I can get this to show in PA like a regular breakdown, it will be far more useful than breaking the flow and showing this other report to see the data.

Thanks in advance everyone. First time poster, long time searcher for help!

Jeff

[Josh Cooper]

Ah okay, so for a Choice field, the actual choices live in the sys_choice table, so it works a little differently.

In your Breakdown Source, the Facts Table will be 'sys_choice', the field is 'sys_id' and you add the conditions to filter to the ones you want.

So in your case, for conditions, you'd use "Table           is         Incident" and "Element       is       <name of field>"   and potentially   "Language       is     en" (if needed).

Then when you build the automated breakdown against that Breakdown source, you'll create a new Breakdown Mapping, for the Incident Table, and point it to the appropriate field, and it should work like a charm!

If you need to, take a look at some of the other breakdown sources that use 'sys_choice', and you should see how to build it as well.

[jlaps]

Josh,

This advice was perfect, I have it working. Advising looking at the other choice_sys was perfect. Now that I know to use choice for those, this makes perfect sense! Thanks again!

Jeff