Creating a interactive filter on a Integer Field

[sayub]

Hi, 

I want to create a interactive filter for 'Reassignment count' field for incidents. It seems i am not able to create a filter on integer fields. Is it possible for do in performance analytics OOTB or are there any work arounds for it if its not possible OOTB?

Sheikh

[Adam Stout]

Absolutely this is possible.  Check out the docs on  Custom Interactive Filters.  I believe there are some other examples in the Community.  We are also running a session at CreatorCon on custom interactive filters.

[sayub]

Hey Adam,

I understand that the interactive filters are possible but i was unable to create a interactive filter on KPI field such as Reassignment count e.g. it didn't let me create a choice filter or anything like that. Can you share some specific screenshot on how to create or a specific community example for creating multi select choice interactive filter on KPI (integer) fields?

I looked at the community and didn't find any specific example so if you can help, that would be ideal or share if there is a blog post/ screenshots on how to create it.

Thanks,

Sheikh

[sayub]

Please find the screenshot attached which will display the error:

[Adam Stout]

Pieter Goris' response to this post walks through a very completed solution.  It is based on calendar dates, but could be simplified for an integer:

https://community.servicenow.com/community?id=community_question&sys_id=c11907e1db5cdbc01dcaf3231f96...