Please help me understand
Your data appears complete - that is there are answers for every question and responder combination - no combinations are missing?
If combinations are missing - they can result in nulls in the viz
if it is not the data you calculated field is creating the null - it would happen with and If..then statement when a record does not satisfy the any of the conditions and there is no "else' clause a Null is generated
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.