Interactive Filters - Display Country Location only

[FrançoisL]

Hi everyone,

Well basic question: I created an Interactive Filter for my 'user survey feedback' dashboard to filter on user's location country. Location is part of the Incident ticket.

I created the Interactive Filter with Reference table 'cmn_location':

In the dasboard, the filter is working, but is displaying full location, which is 'name'. For Australia, I have plenty of cities...

Is there a solution to have a list with only 'country' from Location table?

Country is existing:

Thank you!

[Mark Manders]

I would add a new filter (so you can still filter on location as well) on the country table. And then dotwalk that one to the incident.location.country field.

[Dnyaneshwaree · Accepted solution]

Hello @FrançoisL ,

As the column is a string column, and you would like to show the "Country" column and not the "name" column, you should look into creating a cascading filter, as this will be your only possibility. You can see product documentation and how to create at this link: https://docs.servicenow.com/bundle/utah-now-intelligence/page/use/dashboards/task/create-cascading-f...

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Thank You!!

[FrançoisL]

Thanks!! This video was helpful for the details:

https://www.youtube.com/watch?v=Fw0rq9D5pOI

[Dnyaneshwaree]

If my answer has helped with your question please mark my answer helpful by giving a thumb in the bottom of my post.

Thanks a lot!!