Reporting form a previous point in time

[Brianna Barnes]

I'm being asked to create a report that the user can pick a time and they can see how many tickets were open at that time. Everything I read/do shows me that I can't do this, but I wanted to ask to cover all my bases.

[Jack Brickey · Accepted solution]

It seems like you are looking for a BI solution. I wonder if EasyBI would meet the requirements. Or maybe MS BI. You could certainly export to excel and us excel for this but not ideal if you wish to use this feature frequently 

[Brianna Barnes]

That's what I had initially thought. I'm looking into easyBI but I wanted to make sure I wasn't just missing something. Trying to spare my company some cost. Thank you!

[Thomas Magny-Garcia]

Hi @Brianna Barnes 
I don't think my proposal is as powerful as those already proposed but may you be able to do some reports using createdDate and resolutiondate ?

The query below shows all not completed issues open during the last 60 days

createdDate > -60d AND resolutiondate is EMPTY 

It may be tricky but in my case, it is enough !

Hope it helps!

[Martins Vanags -eazyBI-]

Hi @Thomas Magny-Garcia 

Thanks for joining the discussion.

Your proposed JQL will fail if an issue was open 30 days ago (30 days after its creation) but currently is resolved.

If a user wants to see the number of open issues 30 days ago, this JQL would not help a lot.

But your JQL can help if you need to show all (currently) not completed issues which were created during the last 60 days.

This is a different set of issues as I understand.

Martins / eazyBI

[Thomas Magny-Garcia]

Hi @Martins Vanags -eazyBI- ,
I was just giving an example but you are right the JQL has some limits that, I hope, eazyBI doesn't have.
However, the following query

createdDate < -30d

shows all issues opened at a date before 30 days from today, don't you think?

[Martins Vanags -eazyBI-]

Hi @Thomas Magny-Garcia 

You are right about this JQL query.

However, there is a difference between open and openED issues as far as I understand. The use-case was about the open issues at some point of time in the past. 

Martins / eazyBI

[Martins Vanags -eazyBI-]

Hi Brianna,

@Jack Brickey is right when using eazyBI (Jira plugin) you could create a report using a default measure "Open issues" which would show the total number of issues open at the end of the selected time period.

Please find more on our documentation page: https://docs.eazybi.com/eazybi

Note that eazyBI has a 30 days trial period

Martins / eazyBI support