Forum Discussion
Relationship problem
Hi all,
i hope someone has an idea, what's my problem - because currently I just don't know how to fix it.
I have product cluster as filters and i'd like to visualize data about the faqs shown on the different levels on our website and how they have been rated. (1 asset can have many ratings and 1 asset can belong to many clusters...)
And in the yellow frame i'd like to display a vote ratio.
But when I'm calculating the vote ratio on the fly via quick measure
my table reacts like this:
--> The Asset ID (from factCluster) disappears...Seems like i'm running into a relationship problem...
And if i drag "asset_id" from another factTable than factCluster, the visual isn't responding to the 4 Cluster level filters in the section above anymore...
Thanks in advance!
factCluster has distinct values for "asset id"?
You can try following approach:
- deactivate relationship between dimAsset --> factCluster.
- create relationship between factCluster --> factFaqRatings (I guess it will be m:n)
What happens after adjustments?
3 Replies
- sergej_ogSuper User
factCluster has distinct values for "asset id"?
You can try following approach:
- deactivate relationship between dimAsset --> factCluster.
- create relationship between factCluster --> factFaqRatings (I guess it will be m:n)
What happens after adjustments?- AnonymousNot applicable
no, factCluster doesn't have distinct values for "asset_id".
Your approach was right, sergej_og!
The many-many fixed it 🙂
THANKS
- sergej_ogSuper User
you are welcome 🙂