Create drop-down interactive filter using values from String type field

[Anne25]

Hello,

I have a requirement where I need to create a drop-down interactive filter. The problem is the field type for category is string. Sample values are Desktop PC and Monitor. In drop-down, I need to display these two values only. My display field is Category but since it's a string field, I'm getting all records with category of Desktop/Monitor. 

Does any one has an idea how to create drop-down interactive filter using string field type? I need to display Desktop PC and Monitor only in drop-down. Thank you in advance!

[Voona Rohila]

Hi @Anne25 

can you explain in detail of your requirement and also share the dictionary details of the category field.

[Anne25]

Hello @Voona Rohila,

I have counter widgets for total number of active and inactive assets. These widgets follow the interactive filter I created. My interactive filter supposedly should display two categories which is  Desktop PC and Monitor. Depending on what category will I select, the total number of active and inactive assets should change real-time.

However, category field is a string type of field not a reference nor choice field. When I tried creating an interactive filter with Display field - 'Category', in my drop-down list it displays like the image I attached in my original post. What I need is to display just two values - Desktop PC and Monitor and select between the two.

Thank you!

[Tsura Andreeva]

Hello, are you using the alm_asset to create the interactive filter? Have you tried using class = hardware instead?

[Community Alums]

Please try below link:

https://www.servicenow.com/community/platform-analytics-forum/create-interactive-filter-to-search-on...