How to Create a custom interactive filter for last 3 year

[Varun Pahuja]

Hi Guys,

I need an interactive filter which will show the last 3 years in the dropdown(2018, 2019, 2020) and based on the filter it will show the number of change ticket created on that particular year.

Any idea of how to create an interactive filer which will show last 3 year as an option?

[Malaya]

I don't have licensed version of PA but instead of using Performance Analytic and interactive filter, you can utilize reports and filter will be

Change <date field> = relative = at or after = 3 years = ago

AND

change <date field> = at or before = today

I hope this helps.

Thanks,

Malaya

[Kunal Varkhede]

Hi Varun Pahuja,

You can refer this Blog.

Introduction of Custom Interactive Filter

https://community.servicenow.com/community?id=community_blog&sys_id=aaedd2b7db5480d45129a851ca961988...

Custom Interactive Filter Example:-

https://docs.servicenow.com/bundle/newyork-performance-analytics-and-reporting/page/use/dashboards/r...

Please mark correct/Helpful answer if it help you.

Thanks and Regards,

Kunal.