Estimated Yes / No Chart - Story Points plus another field

Questions & Answers
1

Dear all,

I use a simple graph to show the Number of Estimated vs Unestimated Items.
Considering just the field Story Points that works fine:

graph

I am using these measures:

  • With Story Points is easy, just “[Measures].[Issues with Story Points created]”
  • Without Story Points is:
    CASE WHEN [Measures].[Issues Created] > 0 AND
    NOT [Measures].[Issues created] =
    [Measures].[Issues with Story Points]
    THEN
    [Measures].[Issues created] -
    [Measures].[Issues with Story Points]
    END

Now I want to consider a second field (Custom Field called “Effort Size”). So I try to create two new calculated measures:

  1. Estimated = Non Empty Story Points OR Non Empty Effort Size
  2. Not Estimated = Empty Story Points AND Empty Effort Size

What would the best way to implement them?
I was triyng some Count and Filter Functions, but I could not get it to work : /

Big thank you in advance.

BR,
Markus

2

Hi Markus,

As in this case, you would like to apply two conditions to each issue, it would be necessary to build a calculated measure using some aggregate function and filter all issues which have one or another condition. For example:

NonZero(Count(Filter(
  Descendants([Issue].CurrentMember, [Issue].[Issue]),
  [Issue].CurrentHierarchyMember.get("Effort Size") MATCHES '\(none\)'
AND isEmpty([Issue].CurrentHierarchyMember.get("Story Points")) 
AND [Measures].[Issues Created] > 0 )))

Lauma / support@eazybi.com

3

Thank you very much, that works perfectly :+1:t4::grinning:

1 Like