Relationship issue

[Roodakker]

Hi, 

I am not getting my relationships to work when trying to visualize survey answers. I have Unpivoted the survey responses, created a separate table for questions and sentiment category. When visualizing sentiment category per question I keep getting the total sum and not per category. 

Grateful for suggestions how to solve this. 

Data tables, relationships and visualizations

[Roodakker]

The solution was to change the value from Survey table to SurveyUnpivot table! Thank you @ToddChitt 

[ToddChitt · Accepted solution]

Can you describe the column chart you are having trouble with? What is the Value that is driving the column height? Is it from the SurveyUnpivot table? It should be. Where is field [CES]?

You might try changing the Cross filter of some relationships to "Both"