How to get a count of BTRBugs Logged

Questions & Answers
2

Hi, @Chelsea.Hess

Welcom to the eazyBI community.

If you have the Issue dimension selected in the rows, then the easiest way to count the bugs, that are linked to the Issue, is by counting the appearance of the separator - “,”

In your case, the formula should look something like this:

CASE WHEN NOT IsEmpty([Issue].CurrentMember.get('BTRBugs'))
THEN 
Len([Issue].CurrentMember.get('BTRBugs')) 
  - Len(Replace([Issue].CurrentMember.get('BTRBugs'), ',', '')) 
  + 1
END

Please double-check the “BTRBugs” name.

There is a good post by my wonderful colleague @lauma.cirule here: Question: Counting the Number of Linked Issues

Kindly,
Ilze support@azybi.com