How to show attributes in platform analytics filter

Saul6
Tera Guru

‎11-20-2025 01:18 PM

Hi Folks, 

We are running into an issue when creating data visualizations in PA. The issue is when you 'edit the filter' after selecting a table. We are using the task table and a customer Task Customer field that links to user table. 

The field already has attributes to show username and email, but those don't seem to be reflected in the condition builder below. It is hard for our end users to know which user to select. Any suggestions? Thank you!

 

Saul6_0-1763673335690.png

 

0 Helpfuls
  • 681 Views
2 REPLIES 2

Darlene York
Tera Contributor

3 weeks ago

Hello, did you get a solution for your question?  I am having the same issue and I am trying to resolve.

 

Thank you

0 Helpfuls

Saul6
Tera Guru
In response to Darlene York

3 weeks ago

We ended up customizing the calculated value for the "name" field on the user table. Here's what we added:

if (gs.getSession().isInteractive()) { // only do for interactive sessions
    if (gs.action.getGlideURI() != "") {

        //this is the API that is used in data visualization
        if (gs.action.getGlideURI().toString().indexOf('api/now/graphql?api=api') != -1) {
            return name + " (" + current.user_name + ")"; // return name and user_name field - ex. John Smith (jsmith)
        }
}
 
in this case "name" was calculated in code above to just be first name + last name and we added those if-statements to append the username only when that method is used. Hope that helps
0 Helpfuls