Sum of estimates and default value

Hi Support Team

I have never used Easy BI before.

I am looking for some help to create this kind of report

As you can see, the rows are labels attached to issues and the columns represents the count of issue and the sum of estimate.

Estimation is a custom field, and of course, this field can be filled or not. I would like to sum all the estimates, by taking a value of 5 by default for the unvalued estimates

I would like keep the possibility when I click on the result of the sum to get through and see the 50 tickets and see for each one the real or the default estimate

For the moment, I create a new measure with this formula

IIF(Not IsEmpty([Issue].CurrentHierarchyMember.get(‘Estimation’)), [Issue].CurrentHierarchyMember.get(‘Estimation’), 5)

But the result is definitively stucked on 5, of course it should be greater than 35 (35 is the sum of evaluates that have been defined)

I guess I should use the sum function but I don’t know which use, and I’m not sure I’m on the right way.

Any help would be most appreciated!


Hi @Ivan.L ,

With a numeric custom field import, eazyBI creates several hidden measures. In this case, you can benefit from the hidden measure “Issues with Estimation created” to calculate the number of issues without the estimation with the specific label. The formula could look similar to the one below:

[Measures].[Estimated Cost, EUR created]
([Measures].[Issues created]
-[Measures].[Issues with Estimated Cost, EUR created])*50

See also the screenshot of the report:

See more details on the hidden measures imported with a numeric custom field on the eazyBI documentation page - Custom Fields - eazyBI for Jira.

Roberts //