Custom Interactive Filter for Field within Location table

[ESanchez013]

For the incidents table, I want to build a dashboard where I can filter based on a value in the Location field.

Within the location table, I have a field called "area."

If I reference "Area" in the filter, it instead lists all Locations that are in the areas I listed.

I don't want the user to pick the location, but rather be presented with an option of all available areas and, when they select that area, it filters all Incidents for locations matching those areas.

[AndersBGS]

Hi @ESanchez013 ,

I'm sorry, but not quite following what you are trying to achieve. Can you please give some more information for your issue? or a screenshot of your issue with further explanation? 

For documentation on how to create interactive filters, please reference: https://docs.servicenow.com/en-US/bundle/utah-now-intelligence/page/use/dashboards/concept/c_Homepag...

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

Best regards

Anders

[ESanchez013]

I want to build out a filter that allows me to select the "Area" of the location.

However, when building out the Interactive Filter settings, I make reference to the [cmn_location] table (where the locations reside) and then the string field "Area" because I want it to contain Texas, but instead, it starts returning all the locations.

The Interactive Filter should only have three options: Central Texas, North Texas, and Southeast Texas.

[AndersBGS]

Hi @ESanchez013 ,

What type of column is the area column?

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

Best regards

Anders

[ESanchez013]

"Area" is just a string (text) field.