Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,364,802
Community Members
 
Community Events
168
Community Groups

EazyBI - How to Count Issues (History) without Story Points

Hi everyone,

i want to create a chart which displays the number of issues without storypoints (isempty([Issue].get (“Story Points”)?) or With 0 Storypoints for any given date (issue history).
I tried this code

Count
(
Filter(
Descendants([Issue].CurrentMember, [Issue].[Issue]),
[Measures].[Issues created] >0
AND
(
[Measures].[Story Points history] = 0
OR
IsEmpty([Measures].[Story Points history])
)
)
)

and also this one

count(
Filter(
Descendants(
[Issue].CurrentMember, [Issue].[Issue]),
[Measures].[Issue history]>0
and
(
isEmpty([Issue].get(‘Story Points’))
or
[Issue].get(‘Story Points’)=0
))
)

where both actually arent working properly, at least the values are not correct. Any suggestion what is wrong with this code? I also tried some variations with the [Issue History] Measure, but both history-measures in combination are crashing the report.

Regards,

Lars

2 answers

1 vote

Hi @Lars ,

I recommend importing the "Story Points" field as a dimension and using the "(none)" member together with the measure "Issues history". That way, you will be able to determine how many issues without Story points you had at any given point in time.

To import "Story Points" as a dimension, add the parameters below to the eazyBI advanced settings:

[jira.customfield_NNNNN]
data_type = "integer"
measure = true
dimension = true

Replace NNNNN with the ID of the custom field "Story Points". Then, after updating the eazyBI advanced settings, select the field "Story Points" for import as a dimension. Finally, you can create a report similar to the one below:

Screenshot 2021-12-06 at 19.58.17.png

 

Best,

Roberts // support@eazybi.com

0 votes
Fabian Lim Community Leader Dec 04, 2021

Hi @Lars

You can find details on how to calculate this in this post: https://community.eazybi.com/t/backlog-health-count-of-issues-without-story-points/1628/9

Regards.

Suggest an answer

Log in or Sign up to answer
TAGS

Atlassian Community Events