Counting user-stories that have logged time but don't have SPs

Questions & Answers
1

Trying to create a report that aggregates per project the amount of user-stories that have logged time but don’t have story points.

Ex.
Project 1 | xx stories
Project 2 | xx stories
Project 3 | xx stories

When using the following an “Out of Memory” error appears.

Count(
Filter(
Descendants([Issue].CurrentHierarchyMember, [Issue].[Issue]),
NOT IsEmpty([Measures].[Hours spent]) AND
([Issue Type].[Story]) > 0 AND
IsEmpty([Issue].CurrentHierarchyMember.Get(‘Story Points’))
)
)

2

Hello @Omer_Philip,

Most likely, your report has many projects in Rows that cause the report timeout.
My recommendation would be to create a new dimension with JavaScript code. You can do that in eazyBI settings → Advanced Settings by pasting the code below.

[jira.customfield_loggedtime]
name = "Issues with Logged time"
data_type = "string"
dimension = true
javascript_code = '''
if (issue.fields.timespent > 0) {
if (issue.fields.customfield_10400) {
issue.fields.customfield_loggedtime = "Logged time with SP";
} else {
issue.fields.customfield_loggedtime = "Logged time without SP";
}
} else {
issue.fields.customfield_loggedtime = "No logged time";
}
'''

Once you have saved your settings, import your custom field as a dimension (Account → Source file → Jira import options → ​Custom fields​).
When you have added the new dimension in Pages, you can filter the report on the required parameter (Logged time without Story Points).

947d267eba4517949987b8cf22076920.png

Please don’t hesitate to contact me if you need any more information.

Elita from support@eazybi.com

1 Like
3

Hi @Omer_Philip,

There are several approaches how to count issues with logged hours and without any Story points. The solution with the JavaScript calculated field “Issues with Logged time” would work nicely.

Here is another alternative for consideration.

  1. Import “Story Points” as a dimension. This would allow you to see how issues are distributed by story points and quickly see which issues have (none) story points. Most likely you can re-use this dimension in some other reports.

    1.a. If you have eazyBI version 6.6 then yuo can do this in import options: Custom field import options.
    In import options, find the field Story Points and choose Edit in the Advanced settings column. Then mark the option Dimension and Save changes (see picture below). Now you can select this field for data import as dimension.

    8b50db362b9cd12ee9d6cfcf748064f4.png
    8b50db362b9cd12ee9d6cfcf748064f4.png600×569 52.3 KB

    1.b. If you have older eazyBI version, please see this community post on how to import Story Points as dimension: How to create a histogram - #2 by daina.tupule.

  2. Now you can update the calculated measure and use a much faster expression - a tuple of measures Issues with hours spent, issue type Story and Story points (none) .

    ([Measures].[Issues with Hours spent], 
[Issue Type].[Story], 
[Story Points].[(none)])

Best,
Zane / support@eazyBI.com

1 Like