Calculating job transition time in Marketing Production workflow

Hi Guys

I work for a company using EazyBI for Jira product with a 10k user base, having moved our full marketing production tracking in to JIRA over 12months ago now, based on some reasonably complicated workflows. We’re now looking to EasyBI to help us move from basic reporting to produce much more detailed insights based on the rich data we now have.

Our workflow statuses look something like: DRAFT, JOB OPEN, SUBMIT OUTLINE, OUTLINE REVIEW, SUBMIT BRIEF, BRIEF REVIEW, IN PRODUCTION, LIVE.

We’re trying to build a calculated measure which tells us how long it took for the job to get from JOB OPEN status to LIVE status, and I was hoping someone could tell me if it’s possible to build a query to look at that?

Thanks in advance

Tom

Hi @bloke125,

You can measure cycle time in particular statuses using historical measures with dimension Transition Status. Those measures represent data from issue change history. There are a list and description of those metrics and how those work:
https://docs.eazybi.com/eazybijira/data-import/jira-issues-import/import-issue-change-history

We have created several templates fo Cycle time reports and solutions you might want to start with.
Report templates are available in the Demo account. You might want to start with those:
https://eazybi.com/accounts/1000/dashboards/7513-age-lead-and-cycle-time

And several solutions are described in listed Community posts as well:



Best,
Zane / support@eazyBI.com