Trying to only create a measure that sums only high and critical defects

Questions & Answers
1

I am trying to create a measure that only includes the number of bugs created which have a priority of Critical or High. Not having any luck doing so (also new to EazyBI). Thanks for your help.

2

Hi @NickSocci,

You can use a tuple expression to get a count of created bugs by a specific priority. For the expression use measure “Issues created”, dimension “Issue Type” to get only bugs, and dimension “Priority” to specify priority (for example, High). The expression might look like this:

(
  [Measures].[Issues created],
  [Issue Type].[Bug],
  [Priority].[High]
)

If you want to get a count of High and Critical bugs, you can add up two tuples:

(
  [Measures].[Issues created],
  [Issue Type].[Bug],
  [Priority].[High]
)
+
(
  [Measures].[Issues created],
  [Issue Type].[Bug],
  [Priority].[Critical]
)

An alternative option is a function Sum(), for which you can specify priorities and then sum up created bug count like this:

Sum(
  --set expression, list of priorities of interest
  {[Priority].[High],[Priority].[Critical]}
  --numeric expression, tuple to get created bug count
  ([Measures].[Issues created],
  [Issue Type].[Bug])
)

More details on tuple expressions and aggregate functions are explained in the documentation:
Calculated measures.

Best,
Zane / support@eazyBI.com

3

It worked.
Thank you Zane.

1 Like