Hi, I’m creating a dashboard to report the epic progress of my projects. As a first widget, I’m trying to show how many Epics are InScope, Open, InProgress and Complete.
I created three measures using Issue Created, Issue Resolved and Issue Due. I’m unable to get the In Progress count. Even though I have changed the status of the Epic, it is counted under Open Status. I need some help here to bifurcate all the statuses.
Hi, @anoopkrkumar
It’s great to have you in the eazyBI community!
To have the Jira changes into eazyBI, please perform the data import. eazyBI is a non-real-time analysis tool, meaning data should be imported first. Please read more here: Data Import
If this is not the case and Import has been performed, please open the report at Table view and send the print screen, and, please provide the formulas you are using for “In Scope”, “Open”, and “In Progress”.
Kindly,
Ilze support@eazybi.com
Thanks, Ilze for the response. Yes, the Data is imported.
Here are the formulas I’m using.
Inscope: ([Measures].[Issues created],
[Issue Type].[Epic])
Open: ([Measures].[Issues due],
[Issue Type].[Epic])
Completed: ([Measures].[Issues resolved],
[Issue Type].[Epic])
My requirement is I want to show how many epics are in scope, and how many are complete out of it and then bifurcate them as per their status. Since I’m using the Issues Due measure, even if the epic is moved to “In Progress” or “In Analysis” status, they all come under the Open status. I’m unable to give that entire view here.
Hi,
Thank you for the additional information.
Measure Issues due (or unresolved) are the issues that do not have a resolution and have a resolution date.
Measure Open Issues on the other hand, are calculated as Issues created minus Issues resolved from the beginning of the time until the end of the selected time period.
To see InProgress, I would suggest creating a new calculated measure using a tuple:
Epic in Progress:
([Measures].[Issues due],
[Issue Type].[Epic],
[Status].[In Progress])
Kindly,
Ilze support@eazybi.com
Thanks a lot ilze, that worked Charm. Just one more query, is there a way I can display O. For example, if none of the epics are In Progress, I can show 0 under the In Progress heading.
Hi, @anoopkrkumar
I’m genuinely sorry for not answering sooner.
Please use our built-in functionality “Empty as 0” to achieve the 0 instead of empty cells. Please see the printscreen:
Kindly,
Ilze support@eazybi.com
Thanks ilze! It worked 
