I have a question composite issue. My client has a question composite that asks patients to rate their stay at a particular hospital. Well this response column should only return ratings which would be one through one hundred. The issue is that this column also takes into account the yes or no responses as well and this screws up the average response. Is there a way within the RPD to illiminate this column from taking the yes or no responses into account?
Help is much appreciated....
I would suggest to evaluate these Yes and No values in the form of Number format so that you can add them in 1 to 100 rating.
See that how you can fit in your data, I treat Yes=1 and No=0 to sum up to the rating.
Then you may convert them to 0 using case condition something like cast((case when col>0 then col else 0 end) as int)
assuming the column is string datatype.
I assume they might be doing similar logic to exclude using Excel..