The CreatorCon Call for Content is officially open! Get started here.

Using Function fields with interactive filters. Based on the value in the filter, Add/Subtract count

charan270
Tera Contributor

‎06-25-2024 12:15 AM

This is what I am trying to implement.

Metrics need to show in the report,
1. Reassignment count between groups

2. Reassignment count within XYZ group(I have a custom field in incident table for this)

3. Total Reassignment count (1+2).

The report should be filtered based on the above criteria. The user should be able to filter the count between groups, withing XYZ group and Total count.
I couldn't find any solution for this. Is this even possible?

0 Helpfuls
  • 243 Views
1 REPLY 1

Yashsvi
Kilo Sage

‎06-25-2024 12:20 AM

Hi @charan270,

please check below links:

https://www.servicenow.com/community/itsm-forum/add-an-interactive-filter-based-on-a-field-from-a-re...

https://www.youtube.com/watch?v=OirwryvgCrM

Thank you, please make helpful if you accept the solution.

ServiceNow - Create and Add Interactive Filters to Dashboards in Madrid
ServiceNow - Create and Add Interactive Filters to Dashboards in Madrid
youtube.com/watch?v=OirwryvgCrM
Items demonstrated/discussed in this video: * Navigated to Dashboard with the following types of Interactive Filters: - Date - created an interactive filter based on the Created and Updated Dates - Choice - Created several Priority Interactive filters - Radio Button, Single, Multiple, Checkboxes ...
0 Helpfuls