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
I would use the filter as is...just display the data in the Issue Statistics gadget on the Dashbaord, filtered on Company
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.