Forum Discussion

Roodakker's avatar
Roodakker
Frequent Visitor
3 years ago
Solved

Relationship issue

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

  • 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"

2 Replies

  • 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"

  • Roodakker's avatar
    Roodakker
    Frequent Visitor

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