Help with some reporting on some customer issue types.

[Stu]

Hi, I have the Jira cloud version.

I want to create a report or a widget to display some metrics in my project.
My project has the following custom Epic and Issue Types:

1. Engagements (Epic)
2. Ideation (Issue Type)
3. Proof of Concept PoC (Issue Type)

Ideation and PoC issue types are linked to Engagements (epics).
I want a report that shows me for each Engagement:

1. How many have ideation issue types, what are their workflow status, Issue name, and how many weeks in that status

1. How many have PoC issue types, what are their workflow status, Issue name and how many weeks in that status

I have installed the Script Runner Add on in case that helps. 
Many thanks in advance for your help.

[Tarun Sapra]

Hello @Stu

Since you have script runner installed, you can easily implement these requirements.

Please read all the functions available in these 2 links and try them out based on your requirements.

http://scriptrunner-docs.connect.adaptavist.com/jiracloud/enhanced-search.html

http://scriptrunner-docs.connect.adaptavist.com/jiracloud/jql-aliases.html