How to add filter condition in report dashboard

abhisekpramanik
Tera Contributor

Hi Guys,

We have a requirement to create a dashboard content some report generates on particular or predefined time interval .

Now it is required to add the same filter condition in the reports on dashboard where the condition can be select dynamically as per user's requirement .

I have tried to do by "Interactive Filter" but not able to find those fields present in report condition .

Is there any way to do this .

Thanks,

Abhisek

4 REPLIES 4

Adam Stout
ServiceNow Employee
ServiceNow Employee

What did you try with Interactive filters?  What you are describing is the use case for them but they have to be configured.  What aren't fields available? Can you include some screenshots on what you are trying to do and what you have tried?

If all else fails, you can write a custom interactive filter.  There was a session on this at CreatorCon (which is available to all K18 attendees) or you can start with the docs site that has the basic info on it.

Tracy Davis
Giga Guru

I've been playing around with the Interactive Filter but haven't had much success, especially with the date fields.

Not sure how complex your report is, but if you do it in PA - PA gives the user the ability to choose the date range their looking at. Not an exact date range selector, but allows them to choose 1 month, 3 months, 1 year, etc.

 

abhisekpramanik
Tera Contributor

I have one report called P1 and P2 incident count  with filter condition depicted below .

 

 

find_real_file.png

 

My requirement is  " Created ' condition should appear to the report when published into dashboard like below .

 

find_real_file.png

 

Any solution please .

Thanks,

Abhisek

 

 

 

you could do the Trend chart based on Created Date and select Weeks or Months - that would display weeks or months for the columns. Then you could add a group by option for Priority

 

find_real_file.png