Forum Discussion
shaboo
3 years agoFrequent Visitor
Visual only shows data if data in another visual
My apologies if this has been answered before, but I was unable to find this exact issue. I have visuals that appear to show data from one table ONLY IF there is correlating data on another table....
- 3 years ago
Hi
I see you use Middle Table "Fact Join" to connect Activity and Goal table, but these are many-to-many relation. I think you can direct relate form Goal table to Activity by many - to - may relation.
In your case, check in Factjoin table, if there are full Type rows in column (Include type Meeting), or you can use Type column from Goals table.
HoangHugo
Solution Specialist
3 years agoHi
I see you use Middle Table "Fact Join" to connect Activity and Goal table, but these are many-to-many relation. I think you can direct relate form Goal table to Activity by many - to - may relation.
In your case, check in Factjoin table, if there are full Type rows in column (Include type Meeting), or you can use Type column from Goals table.