PA Breakdown Source on a Custom Table

[Dienne Giuliano]

We have a custom table (CSAT Survey Results) and this custom table references the User table.  I'm trying to create a PA Breakdown Source from this custom table to the User table so I can report on the Agents Country Code which is a list field on the User table.  

In standard reporting, I am able to dot walk from this custom table to Agent.Country Code (Image below)

However, when I try to create a Breakdown Source on the custom table for Agent.Country, I can not access Country Code from the element tree 

I need to create Automated and Formula indicators with the Country Code breakdown, any ideas how I can accomplish this?

[marjorie mejia1]

@AndersBGS is there an extra step to make this work in a scoped application?  we use the sys_choice table as our "facts table" in the breakdown source but the dropdown does not show up if a user is impersonated and they do not have the admin role or pa_admin role

[AndersBGS]

Hi @marjorie mejia1 ,

As far as I recall there shouldn't be any additional steps. 

[marjorie mejia1]

@AndersBGS thanks for the quick response!