Workflow Status Check

Question

Hi All,

I'd like to make a Jira Project with the following requirements and I want to generate a eazyBI/other reports,it should help me to track my work, I'd welcome the suggestions

* I'd like to set a particular date/Target date to complete a Task 
* I'd like to set some days to complete each status to complete the overall Task. * Eg, 30days to complete a task I'd give each status 5 days(i.e 6 status)

* I'd like to track this work like* Where I'm standing from where I'm supposed to be?
* Are I On Track / I'm Delayed, If Delayed How many days/time?

Please suggest some best way and If any add-on could help me out I'd welcome that too.

Thanks,

Prabhu

Roberts Čāčus - eazyBI · Answer

Hi @Prabhu Prabhakar ,

Yes! You can use the "SLA Elapsed hours" measures instead of "Days in - " for each Transition Status.

See more details on Jira Service Management measures on our documentation page - https://docs.eazybi.com/eazybi/data-import/data-from-jira/jira-service-management-custom-fields#JiraServiceManagementcustomfields-SLAmeasures.

Best,

Roberts // support@eazybi.com

Prabhu Prabhakar · Answer

Hi @Roberts Čāčus - eazyBI

Is that something I can acheive with SLA's?

Roberts Čāčus - eazyBI · Answer

I am not confident I understand the requirement fully, but maybe the concept below can help:

You can return the number of days each issue has been in the specific Status with the measure "Days in transition status" and the respective Transition Status dimension members. In the chart above, those are represented in the stacked bars. To get the number of days an issue is also in the current status, look for the measure "Days in transition status till now" in the eazyBI Demo account report - https://eazybi.com/accounts/1000/cubes/Issues/reports/61947-issue-days-in-selected-status.

In the background, you can see the same base color areas, representing the number of days "expected" for each status. In the example above, they are hard-coded for all issues the same.

See it as a table chart below:

The Transition Status dimension affecting only one specific measure is achieved with the drill into measure by another dimension functionality - https://docs.eazybi.com/eazybi/analyze-and-visualize/create-reports#Createreports-Drillintomeasurebyanotherdimensionlevel.

Best,

Roberts // support@eazybi.com