Issue created by week trend JQL

[Andrew Mirauta]

Hey guys, 

I've managed to make some great JQL Google sheet charts recently, I've just started doing this for my company. I'm having a hell of a time trying to figure out the JQL that will chart my weekly activity for a long period of time (quarter, 6 months). So say this week I had 100 issues and last week I had 8, can Jira map that going back?

[Andrew Mirauta · Accepted solution]

@Bill Sheboy 

Hi Bill, sorry, long day, I probably could've been more clear. I work in a support department and to me activities mean issues created. 

This is my current JQL: created >= 2021-01-04 AND created <= 2021-01-31 AND project = CRT ORDER BY created DESC

I'm starting to believe however that this isn't a JQL issue, that it's more of my not knowing how to effectively chart my issues. But it could be both. Basically, even if I see issues on a day during the 6 month span as a dot, with the Y axis being the number of issues and the x axis being the time, that would be great. Maybe it's because it's been a long day and I have other stuff on the go but I'm up a creek in that regard.

This sadness is all that I've been able to make. 

[Bill Sheboy]

Hi, Andrew.  Thanks for the additional information.  FYI... Please try to respond in the same thread as that will help when there are multiple suggestions/solutions.  Future community members can then see and upvote what helped them the most to target ideas faster.

And I think you got it spot on: this is a presentation issue not a filtering one.

So, pick your starting point (earliest create date) for your JQL and then present your results by choosing your grouping buckets for the create date.  For example if your JQL was:

project = CRT AND created >= 2021-01-04 ORDER BY created ASC

In Excel, I would grab the data and use a pivot table to group-by week.  I could also do this manually by adding a column to compute the week for the created date and plot by that grouping: week on x-axis and count on y-axis.

I am not Google Sheets saavy, and I expect there are similar capabilities to do the same things.

__Bill

[Andrew Mirauta]

@Bill Sheboy Sounds good, thanks Bill. 

[Bill Sheboy]

Hi @Andrew Mirauta 

Would you clarify what you mean by "activity"?  For example, updated, created, something specific changed, etc.

And, what does your starting JQL you want to update look like now?

Knowing this information will help the community provide you suggestions faster.  Thanks!

Best regards,

Bill