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|
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.
Please sign in to leave a comment.