Report Filter

[pramn]

 we are using Formula indicator to show report ,

Where we want to filter data like group contains Like ABC , how can do that ? is it doable if yes how ?

Thanks for your help 

[Dr Atul G- LNG]

Hi @pramn 

No, you need to search using the name only, or you might need to do some scripting at the filter level to search using conditions like “contains.”

[Tanushree Maiti]

Hi @pramn ,

You can add filtering using a Breakdown, then reference that specific subset in your Formula.

• Ensure you have a breakdown source for "Assignment Group" 
• Now in Automated Indicators ,Add a condition to filter by the Assignment Group:

             Condition: Assignment group.Name contains ABC

Breakdowns for indicators 

Refer: https://www.youtube.com/watch?v=-wv_6U28SLQ

Define a breakdown source 

https://www.servicenow.com/community/platform-analytics-forum/formula-indicator-to-return-string-val...