avg score with null values
Hii,
I have a problem when I calculate the avg score between 2 survey for each dimension and on of them has null values the avg is wrong.
For example :
dim |
Score survey type 1 |
Score survey type 2 |
avg score total |
X1 |
0.97 |
0.80 |
0.89 |
X2 |
0.93 |
1.00 |
0.96 |
X3 |
1.00 |
null |
0.50 |
X4 |
0.70 |
0.25 |
0.48 |
X5 |
0.67 |
null |
0.33 |
X6 |
0.97 |
1.00 |
0.99 |
The avg is 0.5*type +0.5*type 2
on X3 the answer need to be 1 and not 0.5.
what can I do to solve it in the dashboard preferably without changing the model.
Thanks
Sivan
Please sign in to leave a comment.
Comments
1 comment