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

[charan270]

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?

[Yashsvi]

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.