How to group a report

[Sara Lindsey]

Hi Community! 

Does anyone know if it's possible, in the Reports Application, when creating a bar chart, to group by whether a text field contains a particular word? 

I want to see a bar chart with two columns: One for all the incidents where the short description contains the text "Trigger" and one with all the incidents that do NOT contain that word. 

I know I can filter easily on that condition (Short Description contains (or does not contain) "trigger.") And, I can group on the short description itself, but that won't help me, as each short description is unique, except for that text that may be contained within it. 

Any ideas? Thanks! 

[Nia McCash]

You can create a bar char for the first condition (short description contains keyword) and group by Task type field. Since they're all Incidents, you'd only get the one bar here:

Then add another data set with a similar setup but a different condition (short description does NOT contain keyword) and I think this will give you the report you want.

[Sara Lindsey · Accepted solution]

Oh wow I thought I was pretty good with reporting, but I had never even seen this feature, with the report structure, and the new dataset. You've seriously opened up a whole new world of reporting for me that I didn't even know I was missing. Thank you so much!! 

[Pejay]

Thank you Nia, this was very helpful and solved my problem. 👍 🌟