Show Only Results with a Specific Text String in Charts

[Steven Ferguson]

I'm trying to write a query or create a filter in Analytics whereby my charts only include issues containing the text string "AC-" in the Summary field.  Attempts using a filter of Summary= "AC-*" or Summary like "AC*" don't seem to be working.  Any tips?

[Raghavendra Amara]

While applying the filter in the chart on Summary, you should give

summary like '%AC%' - if you want to get all the records where 'AC' is mentioned

summary like 'AC% - if you want to get all the records where Summary starts with 'AC'.

I just tried and it working as expected.

[Steven Ferguson]

Worked perfectly.  Thank you.

[Brandon Davies]

You can use the regex option instead of like, summary that matches regex "AC-", you might need to test a few different regex patterns to get what you need exactly.

For example, if you want to find only summaries that start with AC- or simply containing AC-

[Steven Ferguson]

It's a school day for me, Brandon.  Thanks.