EazyBI - Calculated Field - Count distinct specific field value on specific isssue Edited

Hello All,

I'm having some hard time regarding EazyBI and calculated fields. Just starting coding on calculated fields since 2 days, and I can't figure out how to achieve my goal.

Thanks in advance for your help!

 

JIRA setup:

On each "Sub-work" issue type, I'm having a field "Deliverable ID" in which teams can write something, or not.

For the teams which have written something inside "Deliverable ID", we have a Scripted Field "Status" which is going to define the issues' status.

Goals:

- Have a column displaying the # of distinct "Deliverable ID" value, per teams

- Have a column displaying the # of "Status" value "In Progress" for the distinct "Deliverable ID" value, per teams

 

Exemples on JIRA DB:

- Issue A, Deliverable ID = "Int1", Team = "T1", Status = "In Progress"

- Issue B, Deliverable ID = "Int1", Team = "T1", Status = "In Progress"

- Issue C, Deliverable ID = "Int2", Team = "T1", Status = "Not Started"

- Issue D, Deliverable ID = null, Team = "T1", Status = null

To be achieved:

The columns I try to have on my EazyBI table are (per teams):

- # Deliverable ID (here it will be: 2)

- # In Progress (here is will be: 1)

 

Rows:

- Dimension: Team

Columns:

- Dimension: Deliverable ID

(I also tried to do it with "Measures" Dimension, adding the "deliverable ID" field inside of it, but I'm getting same result)

 

What I've tried for the "# In Progress" and is closer to what I want to achieve:

count(Filter(Distinct(
[Deliverable ID].[Deliverable ID].Members),
[Measures].[Issue type] = 'Sub-work' AND
[Measures].[Issue Subwork Interface Status] = "In Progress"))

-> Result = 2, instead of 1

 

What I've tried for the "# deliverable ID" and is closer to what I want to achieve:

count(distinct(Generate(NonEmptyCrossJoin(
[Issue].[Issue].Members,
[Deliverable ID].[Deliverable ID].Members),
[Deliverable ID].CurrentMember)))

-> Result = 3, instead of 2

 

Thanks.

Regards,

1 answer

This widget could not be displayed.

Hi,

the following formula could be used to count the number of deliverable IDs:

count(
  Filter (Descendants ([Deliverable ID].[Deliverable ID].Members),
  ([Measures].[Issues created],[Issue type].[Sub-work])>0 and 
  [Deliverable ID].CurrentMember.Name <> '(none)'
  )
)

 This calculation can be used in the report with the dimension "Issue Subwork Interface Status" and it would give the count the Deliverables by the Status dimension of the Issues.

Suggest an answer

Log in or Sign up to answer
Community showcase
Published Aug 22, 2018 in Marketplace Apps

How a Marketplace app tech team is achieving gender diversity

Hello! My name is Genevieve Blanch, and I'm the Marketing Manager at RefinedWiki, creators of apps to give teams the tools to customize Atlassian platforms. Currently, 44% of the tech team at Re...

512 views 3 18
Read article

Atlassian User Groups

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

Find a group

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

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you