Data ratio

[Syndicate_Admin]

Good night

I have two datasets in my BI and for some reason I can't get data realization to work properly. the data comes from a campaign dailler report that is mixed into the site's absence report. I would like to combine the data that allows me to cross the reports and return the daily hours of the timesheet. I've tried a realization between the agent's name and His_userfullname and a seprate like Su-calldate and timesheet date.

unfortunately I'm not getting the results I need. Am I missing something stupid?

Should relationships have the same title?

thank you in advance

[MFelix · Accepted solution]

Hi,

The problem with your model is that you have a many to many relationship, meaning that you get multiple result from both tables at the same time giving you multiple calculations.

What you need to do is to a dfimension table to relate both tables with unique values in this case the Userfullname and then make the relationship one tro many from that table to the other two.

This should give expected resutl.