Get a unique list from a filter

[Lecathelinais Eric]

Hello,

I need to know if it's possible to get unique list from a search string. For example in following search string,

"project in (project1, project2, project3, project4) AND ("Product - Component" = component1 OR "Product - Component" = component2) AND createdDate >=2017-01-01 ORDER BY Company"

Imagine that this query returns 2000 tickets.
100 tickets with Company1
500 tickets with Company2
600 tickets with Company3 
800 tickets with Company4

I would like to get unique Company list. So just 4 results:
Company1, Company2, Company3 and Company4

I know  I can export the list in Excel and filter results but i have to do this every week. Hence looking for some automatic way.

Someone will have a solution ??

Thanks

[Rahul Khire]

I would use the filter as is...just display the data in the Issue Statistics gadget on the Dashbaord, filtered on Company

[Lecathelinais Eric]

Great, thanks @Rahul Khire.