Reports - Group by keywords in Short Description

RoSma · ‎07-18-2024

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 · ‎07-18-2024

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.

Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark

View solution in original post

Tai Vu · ‎07-24-2024

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

View solution in original post

Mark Manders · ‎07-18-2024

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.

Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark

AndersBGS · ‎07-18-2024

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

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

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

Tai Vu · ‎07-18-2024

Hi @RoSma

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

RoSma · ‎07-23-2024

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