Get the number of issues planned on a project in easyBI

imen · May 4, 2020, 9:31am

I want to create a customized field in easyBi that indicates the number of planned tasks

how do i get these values??

zane.baranovska · May 25, 2020, 10:45am

There are several ways how to get planned tasks according to the method of how you mark those planned tasks in Jira. Is it some date field or status?

If planned issues are unresolve issues with some planned resolution date, like “Due date”. Then you may use measure “Issues with due date” together with dimension Resolution , and select resolution (unresolved) . To get a report only on tasks, use dimension Issue Type on pages.

Planned tasks with due date1582×820 113 KB

If you would like to represent the same results as a calculated measure, then you may use a tuple of measure and mentioned dimensions like this.
```
(
  [Measures].[Issues with due date],
  [Issue Type].[Task],
  [Resolution].[(unresolved)]
)
```
More details on calcaulted measures and tuples are described in the documentation: https://docs.eazybi.com/eazybijira/analyze-and-visualize/calculated-measures-and-members/calculated-measures.
If planned issues are issues in a special status, then you may use measure “Issues created” together with dimension Status , and select statuses of interest. To get a report only on tasks, use dimension Issue Type on pages.

Planned tasks by status1628×762 113 KB

You may also start by checking out some examples of due issues in eazyBI Demo account:
https://eazybi.com/accounts/1000/dashboards/4553-jira-issues