Forum Discussion
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.
In the below example, I want to see the goal called Meeting (Goals Set visual), even if there is no matching Goal Hit (Goals Hit Visual).
AND...I want the Goals Hit to show Meeting, even if there is no data.
I have selected for all visuals "show items with no data", and it still doesn't show up.
In the below example: You see that on the goals set visual, it is not showing the "meeting" type of goal, because the goals hit visual does not have a match (for the same time period, person, etc).
And you can see there is clearly a Meeting goal in the table: (this is the goals table)
How I have the relationships joined:
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.
1 Reply
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.