question Re: Creating a interactive filter on a Integer Field in Platform Analytics forum

Creating a interactive filter on a Integer Field

sayub — Fri, 02 Mar 2018 17:28:45 GMT

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

Re: Creating a interactive filter on a Integer Field

Adam Stout — Fri, 02 Mar 2018 17:41:37 GMT

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.

Re: Creating a interactive filter on a Integer Field

sayub — Fri, 02 Mar 2018 17:51:45 GMT

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

Re: Creating a interactive filter on a Integer Field

sayub — Fri, 02 Mar 2018 18:00:01 GMT

Please find the screenshot attached which will display the error:

Re: Creating a interactive filter on a Integer Field

Adam Stout — Fri, 02 Mar 2018 19:09:34 GMT

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=c11907e1db5cdbc01dcaf3231f961912&anchor=answer_42346479db1c5fc01dcaf3231f9619d1&view_source=searchResult

Re: Creating a interactive filter on a Integer Field

Adam Stout — Fri, 02 Mar 2018 19:10:54 GMT

If you need a simpler example (this one can be a little complex), take a look at the very basic custom interactive filter example in the docs.

Re: Creating a interactive filter on a Integer Field

sayub — Fri, 02 Mar 2018 19:22:48 GMT

Thanks Adam,

So based on my understanding its not a OOTB just creating a interactive filter from the UI like we do for dimension fields defined as string or date etc. Based on the post i see its more like writing a script to achieve that. Is that correct?

Re: Creating a interactive filter on a Integer Field

Adam Stout — Fri, 02 Mar 2018 20:13:13 GMT

Correct. You can't filter an integer field with an OOTB Interactive Filter, you have to go custom. Same goes for filtering a string (that is not a choice list or reference). Luckily, this is pretty straightforward.