Combine 2 datasets with join or append while preventing duplicates
I have 2 datasets:
- 1 containing conversions per day per product
- 1 containing the costs per day (in total)
I am trying to get to this:
But I end up getting this
As you can see I get the wrong calculations do to Domo forcing every field to have the same cost.
Total 1 & Total 2 are 2 different companies to make it even more difficult.
Is there any way to prevent this or is this just the nature Domo works?
Thanks in advance