on 12-10-2014 7:25 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.