Reports - Group by keywords in Short Description

RoSma
Tera Contributor

Hey Guys/Girls,

I would like to know how to made a report and group by a specific Keywords contained in Short Description.

Exemples :
all ticket are INC, without catalog service.
Filter is :
Short Description contains "Banana"

OR
Short Description contains 'Apples"

I would like to have 1 graph (report > type > bar) with, for example, all tickets with "Banana" in Yellow and all tickets with "Apples" in Red but group in the same graph (like we can have with the state ("Work In Progress" in green and "Closed" in blue).

For the moment, I see all tickets related to Banana and Apple but without differentiate them in the bar colors

Thx in advance,

2 ACCEPTED SOLUTIONS

Mark Manders
Tera Patron

This is not possible. You can't group by part of a string, unfortunately. If you really need to know the numbers, you can put single scores on a dashboard.

Since I don't think you are working for a fruit farmer, you may want to look at some other logic. Use some sort of choice field to be filled by a BR that get's the word out of the short description to show what fruit the ticket is about.

 

View solution in original post

Hi @RoSma 

The best approach would be to have a field for categorization, as Mark proposed.

Alternatively, if you have a limited number of elements (like 5), you can leverage the Dataset feature within Report.

Sample below.

Timi_0-1721877987602.png

Timi_1-1721877994094.png

 

Cheers,

Tai Vu

View solution in original post

8 REPLIES 8

Mark Manders
Tera Patron

This is not possible. You can't group by part of a string, unfortunately. If you really need to know the numbers, you can put single scores on a dashboard.

Since I don't think you are working for a fruit farmer, you may want to look at some other logic. Use some sort of choice field to be filled by a BR that get's the word out of the short description to show what fruit the ticket is about.

 

AndersBGS
Tera Patron

Hi @RoSma ,

 

The short answer is that it's not possible.

 

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

 

Best regards

Anders

Tai Vu
Kilo Patron

Hi @RoSma 

How many keyword elements will we have in the chart? Only 2 Banana and Apple?

RoSma
Tera Contributor

Heyy?
Thx for these replies 🙂

@Mark Manders 
Yea, it's not fruits related as you can imagine.
What do you mean by "BR" ?
I don't know how to "group" by" or something like this

@AndersBGS 
Thx for the reply, it's clear and exactly what I expected 🙂

@Tai Vu 
For the moment 5 but at the end, it could be more than 10