Forum Discussion
Relationship Not Working
Thank you in advance for any support you can provide. I am having an issue with relationships I believe and am loojing for support.
I am attempting to have my goal filtered with the splicer that filters other values in my dashboard. The periods measured are called AIRAC in my table. Individuals have goals for each AIRAC; therefore I have 20 disticnt goals each AIRAC and they vary from AIRAC to AIRAC.
In my date table I have an AIRAC field that links to a separate "AIRAC Key Table" with a one-to-many relationship. Separately, I have a roster table that links from analyst to analyst in a one-to-many relationship. All of my other fields are filtering correctly with the relationships, the cycle goal however does not filter when i select individual AIRACs, i.e "Cycle 1803".
Goal TableFiltered ViewUnfiltered View
Jondon29 can i see the actual relationship view of how the tables operate together? i think the problem is that your direction is single between each relationship, therefore the flow between the 3 tables is being interrupted somehwere. it just depends on what direction the relationship is going, and what field you are using to slice on. make sense?
4 Replies
Jondon29 are you sure the relationships you have set up are definitely one to many? can you provide a screen shot of the relationships
vanessafvg, of course!AIRAC Key to Date TableAIRAC Key to GoalRoster to Goal
Jondon29 can i see the actual relationship view of how the tables operate together? i think the problem is that your direction is single between each relationship, therefore the flow between the 3 tables is being interrupted somehwere. it just depends on what direction the relationship is going, and what field you are using to slice on. make sense?
