EazyBI - Calculated Field - Count of Stories in a calculated Member

Ayman
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 21, 2017

Hi all,

 

I am new to EazyBi and calculated fields. Hope you can help me with this one.

 

I have the issue type as my column, where I  am displaying the number of Epics and number of stories for a custom field. Instead of displaying the default count of stories, I want to put a criteria on the count of stories. So, I want to create a calculated member to count the stories on a certain criteria.

 

Hope this makes sense

 

Thanks,

AK

1 answer

0 votes
eazyBI Support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 27, 2017

Hi,


You may define a new calculated measure using a tuple.

For example, to count created stories with priority Major, a formula may look like this:

([Measures].[Issues created],
[Issue Type].[Story],
[Priority].[Major])

For more complex criteria, additional calculated members in other dimensions or iterating through all issues using function Filter() would be needed.


Please contact support@eazybi.com if you have further questions regarding this!


Regards,

Zane Baranovska / support@eazybi.com

Suggest an answer

Log in or Sign up to answer