cancel
Showing results for 
Search instead for 
Did you mean: 

Risk Assessment Heat map help

Former Member
0 Kudos

Hello experts:

Can some one please help how to approach in creating a WEBI report for risk assessment.

I have the risk scores ( two types) and these scores should be aggregated based on division  ( in 1st heat map)

And scores should be aggregated based on risk category on the second one .

Can some one please help me thru this. step by step process ?

PS- the scores i have is a dimension. Should I be creating Variable to use in the heat map?

Thank you in advance

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Rishi,

I suspect I am not understanding the issue. I visualize a simple table for each heat map:

Table 1

Division, Risk Category (optional), Score1, Score 2, Sum of the scores (if that's what you mean by aggregate)

Table 2

Risk Category, Division (optional), Score 1, Score 2, Sum of the scores

If the issue is that the scores do not aggregate due to being a Dimension/string then yes, create a variable for each and convert the string to an integer in the variable formula using ToNumber([Score Dimension]). Then use the custom variables in the report.

If the issue is that the scores are in one dimension, there is something that relates to the score that keeps them distinct. Then use that when creating the two new variables. Let's call that data that makes the scores distinct the Score_Code. I assume there are just two in the data:

=ToNumber([Score_Dimension]) WHERE ([Score_Code] = " the code value for Score 1")

I sense something more is involved.

Former Member
0 Kudos

Bob,

Thank you for your time, Yes your reply does help me. As you suspected there is more involved in this scenario. I just gave the general version.

Is there a way that I can PM you actual requirement?