Reports - Group by keywords in Short Description

[RoSma]

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,

[Mark Manders · Accepted solution]

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.

[Mark Manders]

BR is business rule. And the solution is to create some kind of field you can do a group by on, which you fill from the BR (so is short description contains apple, you make it apple, if it contains banana, you make it banana). It is just a way of categorizing for reporting purposes.

[RoSma]

Ohh ok, thx

I'm not admin on the platform so I'll try to talk with the admins and explain my problem and ask if it's possible to create this kind of BR.

Thx a lot for your help !

Have a nice day

[Tai Vu · Accepted solution]

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.

Cheers,

Tai Vu

[RoSma]

Heyy Timi !

It's exactly what I wanted !!
Thx a lot for your help 😄
I'll try to create a dedicated field with our admin's but it's clearly a very nice temporary solution