Line Chart Issue

[Anonymous]

Hi I am Using a Clustered column chart to create a table where it will show all program(Houses) total with the Line  showing the capacity of the houses. I have 3 houses with capacity 6 in each house. When I click on multiple houses, it doesn't show the total capacity in both the houses which should show 12 (6 in each house), but it shows 6.

Let me know if you need any other information.

Thanks,

spanda

[Anonymous · Accepted solution]

Hi @Anonymous

This happens often when there isn't a valid relationship set up between two tables. Make sure you have created the relationship and specified "Both" for the cross-filter direction if necessary.

Hope this helps,

Parker

[Anonymous]

Thank you so much @Anonymous !!

The relationship was not set for both ways, that's what was creating this issue.

Regards,

spanda