jql- a ServiceClarity JQL filter to find the JIRA issues of interest
aggregate- the aggregate function to apply, e.g.
SUM(‘In Progress’)or in multiple states
AVG(‘Waiting on third party’, ‘Waiting on customer’)
AVGof the time spent, in minutes, in one or more workflow states of JIRA issues returned by the JQL query
The Time Spent In State collector requires that your JIRA Cloud account or JIRA Service installation has the JIRA Charts plugin enabled. This collector can count the average or total time that JIRA issues spend in one or more stages of the JIRA workflow. For example, with this collector it is possible to track KPIs such as total time in progress, mean time in QA and total time waiting for release.
To configure a Time Spent In State collector you need to specify the JQL, the name of the workflow status and an aggregation function to apply. For example, you could track the average time spent waiting to create a waiting for release KPI.