Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

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

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
Community showcase
Published in Apps & Integrations

Send an Email or Publish to Confluence - What should you do with your release notes?

Background When you hear the words ‘Release notes’, almost always you think of an unsolicited email from a software vendor. But I am here to tell you that from our data, sending release notes via E...

136 views 1 2
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you