Hi @arilai
Welcome to the Community!
This formula does not limit the selected issues by their type. Could it be the case that some of the selected Page filters in your report are limiting the output?
Additionally, you can check out the answers to these Community posts that are describing in detail how to count issues without story points:
Hi @viviane ,
To get a count of issues without story points, you can build a calculation as a count of all Issues created minus issues with story points (for it you may use a hidden measure Issues with Story Points created):
[Measures].[Issues created] - [Measures].[Issues with Story Points created]
Similarly, you can get a count of resolved issues without story points, this time using measures Issues resolved, and hidden measure Issues with Story Points resolved:
[Measures].[Issues resolved]…
Hi Lars,
You were on the right track with the first formula! The incorrect part there is that you first filtered ‘Issues created’ which on Timeline gives only issues created in that period. So you ended up counting just issues created at the period which do not have story points at that period.
Try the following formula - it first filters that issue is created before the end of the selected period end and then makes sure issue is created in all other report context, ignoring Time.
NonZero(Cou…
Best regards,
Nauris / eazyBI support
1 Like