Hello, I'm working on dashboard where I try get the number of deals per region. The total of active deals is 30 and should be split between Europe, America etc.. But I have 30 for each region.
The count of deals is in the Deal table and the region in the company table. The link between these two tables is made with a third table. The screenshoot will help you to understand the undirect relation. I don't know to fix this and I'm almost sure that the probleme is due to the relation. All the data is from a dump of Hubspot (CRM) into my slq server
Thank you 😄
Hii @AntoineOA,
Change the relationship from single to both in each relationship to check whether the total is correct or not.
Go to Model view -> Properties -> cross filter direction.
Did I answer your question?
Mark my post as a solution, this will help others...!
Hit the kudo also,
Thank you.
Hii @AntoineOA,
Change the relationship from single to both in each relationship to check whether the total is correct or not.
Go to Model view -> Properties -> cross filter direction.
Did I answer your question?
Mark my post as a solution, this will help others...!
Hit the kudo also,
Thank you.
Helpful resources
New forum boards available in Real-Time Intelligence.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
