Filter with grouping

[Dima Astahov]

Hi, 

I'm trying to set a Filter and Subscription to get :

<<List of users with at least one active JIRA ticket on their board>>

Is it possible in JQL, something like  TOP 1  or group by user?

Thanks

Dima

[Hannes Obweger - JXL for Jira]

Hi @Dima Astahov

if you're open to solutions from the Atlassian Marketplace, you may want to have a look at the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a range of advanced features, including support for issue grouping by any issue field(s).

This is how it looks in action:

This is grouping by a Category field, but it works for any other fields, too. Issue grouping can also be combined with JXL's other advanced features, such as support for (configurable) issue hierarchies, sum-ups, or conditional formatting.

Any questions just let me know,

Best,

Hannes

[Dima Astahov]

Hallo  Hannes !!! Thanks so much, I'm  IN.  Probably need some time to digest.

Best

Dima

[Dima Astahov]

Exploring sheet now, trying to mimic you demo to make counts, but looks like I'm missing some controls.

[Hannes Obweger - JXL for Jira]

Hi @Dima Astahov

the setup in my demo above is relatively simple; I've changed the sheet scope and the sheet columns to include the data that I'm interested in, enabled sum-ups, and then (as shown in my clip) perform grouping by one of the available columns/fields. 

If you want to see a full demo of the app, I'd recommend having a look at this quick demo video. It gives a great overview. 

Let me know if this helps,

Best,

Hannes

[John Funk]

Hi Dima,

If you are you wanting to see the group by for the Assignee, just create your Filter like it already sounds like you have done. 

Then create a Dashboard or edit an existing one and add a gadget for Issue Statistics. Connect it to your filter. Then use Assignee as the Issue Statistic. 

That should get you want you want - and no add-on or Excel dump needed.   :-)

[Dima Astahov]

Looking at the sheet now, trying to mimic you demo, to count number of assignees, but looks like I'm missing some controls comparing with your demo above, 

Tx again, will need more time to practice.

Best

D

[Matt Parks]

You could add ORDER BY Assignee (ASC or DESC, depending on how you want to view it) to the end of the JQL to group by the Assignee field.

[Dima Astahov]

Hi Matt, 

I did play with filter JQL, I still can not get 1 line = 1 user structure , with ORDER BY  I have 1 issue = 1 line, so user with 10 issues will get 10 rows.  And looks like there is not GROUP BY in jql, can you provide more details/sample

[Matt Parks]

No, there is no Group By in JQL. If you had Structure or a similar plugin, you could use the JQL to populate a Structure and then use their Group functionality.

Another option would be to export the query results to an Excel file and do the grouping there, although I generally don't like to take data out of Jira into Excel.

What problem are you trying to solve?

[Dima Astahov]

Thanks Matt,  I need to setup filter  with subscription to generate list of distinct users having at least one active issue (not Done). Ideally in full Auto mode without dealing with export to excel.

I'm on the cloud standard, went thru few add ons, but looks like they work only on server. https://marketplace.atlassian.com/apps/1218767/

I'm going to check <Structure or similar plugin>. Appreciate if you point me to it,

Overall is this doable just with plugin? I can't explore an option with any extra dev otside of Jira.  

Thanks

Dima

[Matt Parks]

Here's a link to the Structure plugin (for Cloud) on the marketplace:

https://marketplace.atlassian.com/apps/34717/structure-ppm-jira-portfolio-management-tempo?hosting=cloud&tab=overview