Forum Discussion
USERELATIONSHIP() not working with id columns
Hello, I am working with a referal program for a product, it's a pretty simple set of relationships where I have an ID for the referrer and an ID for the referred and they are related to a table ...
Syk
Resident Rockstar
Resident RockstarCan you post a screenshot of your data model? And a little more on what you're trying to achieve.. An average of referred spend?
Hi Syk, I cannot post screenshots. We are working with proprietary data, and I don't think it is necessary to post screenshots for this simple example. We have one table with two ids, we have another table with one id and sums, there are two relationships, one for the referred and one for the referral.
I'm trying to calculate averages for reffered and for refferals sepperately to put in card visuals among a few others.