eazyBi - risk impact and probability multiplication and average

[Guido Santo]

Hi

I have the 2 custom Jira dropdown fields "Impact" and "Probability" (each have values 1, 2, and 3).

I have synced these with eazyBi and would like them to be calculated as average risk rating of all issue populated with these values.

I have created a calculated measure "Issue risk rating" for the rating:

([Measures].[Issue Impact] * [Measures].[Issue Probability])

And then I calculated my measure "Average risk rating":

Avg(
  Filter([Issue].[Issue].Members,
    [Issue].CurrentMember.Get('Impact') > 0 AND
    [Issue].CurrentMember.Get('Probability') > 0 ),
  [Measures].[Issue risk rating]
)

However, this always results in an error in my table:

#ERR: mondrian.olap.fun.MondrianEvaluationException: Expected value of type NUMERIC; got value '(none)' (STRING)

Could it be that Jira dropdown fields are all string, regardless if I enter a numeric value like 1, 2 or 3 ?

How can I resolve this instead please?

[Kat Jansen]

Guido, 

Does your Issue risk rating return any errors when you have that in columns and Issues in Rows?

-Kat

[Guido Santo]

Sorry, this is 2 years ago. No memory of this anymore :)