Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello! I have two data tables: Leads and Contacts. This tables connected by key field "Contact ID". I want use some dimensions, like "Tag", from Contacts table, to slice data from Leads table. But, I don't know why, when i'm using filter in field "Tag", report behave like there is no Lead, that match filtering condition. But this Leads exist, I know it . Why field "Contact ID" don't work like a key? What am i missing?
All detail in my video (sorry my poor English )
Solution founded! If you want use fields from additional table like dimensions for main table, YOU MUST CONNECT THEM ONLY WITH ONE KEY FIELD
This is correct conetion. Example of incorrect connection you can see in my video.
Solution founded! If you want use fields from additional table like dimensions for main table, YOU MUST CONNECT THEM ONLY WITH ONE KEY FIELD
This is correct conetion. Example of incorrect connection you can see in my video.
You have got synthetic keys:
not one field but multiple fields connects your tables cousing your issues
The $S.. indicates the
Look here how to get your data right
Thanks! I'm already solved this and posted solution, bou it still on moderation
Great good for you.