Create a Breakdown for Catalog Tasks by State

tim_treacy
Tera Contributor

I'm trying to create a breakdown on the 'State' of Catalog Task [sc_task] records that I've already built indicators for.  However, when I create the new source record, the 'State' field is not available/selectable on the [sc_task] facts table.

Screenshot_1647.png

 

The field is configured on the form and in the table definition, so I'm unclear why it's not available here.

Screenshot_1648.png

I've tried looking from some method to dot-walk to the RITM or REQ from here and hit one of those records State, but that's not an option either.

So I'm a bit lost on where to go next.

2 REPLIES 2

Tsura Andreeva
Mega Sage

Check out the Incident.State Breakdown Source as a sample

But Incident.State uses 'sys_choice' table for ensuring this.

Here, the state is an Integer field. I can't see how that will help.