How to breakdown map a field from an extended table?

[Dario Marquez]

I have an indicator based on the task_time_work table and I need to break it down by "category" which is a field from the incident table. I already have the "category" field breakdown from the incident table. But in the mapping form, when I try to map it to the task_time_work table, I select in the facts table ="task_time_work" and in the field I am able to get to the "task" table but I am not able to get further to the extended table "Incident". How can I do this? Thanks

[Dario Marquez]

No, but I just tried. I was able to dot walk from time worked table to the task table using the "task" field and so the only thing left is to dot walk to the child table or extended table 'Incident" so I modified my script to this:

And I am still getting that error. I notice that the ambiguous issue persists since the script is not specifying from which extended table to take the category field.

[Adam Stout]

1) Is that script right?  Number is generally a string, not a reference.  I would expect this to be current.task.ref_incident.u_category_ch

This is assuming that u_category is on the incident table, if not, replace the table name after the ref_

2) You should see the expected fields at the bottom of the left side of the slush buckets once you expanded Task(+).  If not, there may be a property you need to enable:

https://docs.servicenow.com/bundle/orlando-performance-analytics-and-reporting/page/use/reporting/ta...

[Dario Marquez]

You are right, I switched to the task field instead of number, and your script worked!

current.task.ref_incident.u_category_ch

It looks like it wasn't necessary to enable the property for the script to work, even though I am not able to see the extended fields at the bottom of the list. 

Thank you very much Adam, you saved my life.