How do we create a filter to show top 5 tickets based on the number of category for example?

[Madelyn Son]

We are trying to create a Service Desk report to show top category selected when raising IT ticket. Please help to provide solution or jql filter.

[Avinash Bhagawati {Appfire}]

Hi @Madelyn Son ,

Please create filter with below simple JQL query and use the same filter in two dimensional filter statistics gadget to dashboard with x axis as category and y axis as assignee and set maximum results to 5.

Thanks,

Avinash

[Madelyn Son]

Hi Avinash,

Do you know what should be the JQL query looks like for this?

Thanks!

Madelyn Son

[Avinash Bhagawati {Appfire}]

Hi @Madelyn Son ,

Can you please use sample JQL like

project = ABC and request type = IT request

Thanks,

Avinash

[Madelyn Son]

How can i show just the top 5?

[Avinash Bhagawati {Appfire}]

Hi @Madelyn Son ,

You need to select number of results as 5 and it automatically shows top 5 results.

Thanks,

Avinash

[Madelyn Son]

Great thanks for the help