Hi @Sandipan,
What you are looking for is quite a complex calculation - for each interval, you would need to create a separate MDX calculation that goes through the set of all issues and sums how many days it has been open since its beginning and till the end of the period. These calculations could be built based on a similar formula for Average age of Open issues in this demo report Average age till resolution report - Issues - Jira Demo - eazyBI, but they could get quite resource-consuming.
I would like to suggest you use the Age and Resolution interval dimensions instead
- You could show the age of currently open issues, e.g. Average age of unresolved issues by issue type and priority - Issues - Jira Demo - eazyBI
- Show how fast the issues were resolved on their resolution date by the resolution interval: Getting the count of issues with a certain age - #2 by lauma.cirule
Let me know if you have further questions regarding this!
Lauma / support@eazybi.com