question Re: Reports - Group by keywords in Short Description in Community Central forum

Reports - Group by keywords in Short Description

RoSma — Thu, 18 Jul 2024 12:19:13 GMT

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,

Re: Reports - Group by keywords in Short Description

Mark Manders — Thu, 18 Jul 2024 12:31:38 GMT

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.

Re: Reports - Group by keywords in Short Description

AndersBGS — Thu, 18 Jul 2024 22:04:19 GMT

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

Re: Reports - Group by keywords in Short Description

Tai Vu — Fri, 19 Jul 2024 03:54:24 GMT

Hi @RoSma

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

Re: Reports - Group by keywords in Short Description

RoSma — Tue, 23 Jul 2024 12:16:14 GMT

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

Re: Reports - Group by keywords in Short Description

Mark Manders — Tue, 23 Jul 2024 14:00:56 GMT

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.

Re: Reports - Group by keywords in Short Description

RoSma — Wed, 24 Jul 2024 05:16:51 GMT

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

Re: Reports - Group by keywords in Short Description

Tai Vu — Thu, 25 Jul 2024 03:29:42 GMT

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

Re: Reports - Group by keywords in Short Description

RoSma — Thu, 25 Jul 2024 09:55:55 GMT

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