JQL - most frequent tasks

[Cs Csarli]

Hello,

I would like to solve a rather complex problem in JQL.

Prelude:

There are several tickets. For example:
summary1: Jira - Need new quick filter
summary2:  jira - report problem
summary3: confluence - plugin update
summary4: JIRA - plugin update

If the maximum number of tickets were four on this week I will see easily: jira was the most problematic topic on this week.

If I want to search all closed tickets, which contains in summary field the "Jira" word, I use this query:
status = solved and status changed after startOfWeek() and summary ~ "jira"

demand:
Need to write a general query, which "say" what was the top5 most problematic topics on this week. Unfortunately the keyword is unknown, this makes it more difficult. :(  Maybe "jira" is the keyword on this week, next week maybe the "network", then "computer"...

I think need count words and compare them, but it is a rather high level problem to solve with general tools. Do you have an idea for a solution?

Thanks in advance

[John Funk]

Hi @Cs Csarli  - Welcome to the Atlassian Community!

I would create some Components on the project for each keyword that you want to report by. 

Then as cards are created, you should update the ticket with the appropriate Component. Then you can easily search by Components.