Hi ,
I am trying to remove duplicates .
I have two datasets.
One dataset consists of targeted customers for a campaign . Second one is the conversion data ( if the customer has come back and made a purchase).
I am using a parameter to set the time to purchase . so that user can filter the orders that ahppened within a time period after the customer was mailed .
The issue I am facing is there are duplicates for the same row. I want to find the total sales from these . But right Now if i am using sum , then it gives the sum of all sales from these duplicate rows. I only want the sum of sales of all unique rows.
Thanks,
Liya
Hi,
Check your join condition. I think you should use the left join your bigger at first and second having short values in table should be on the left side. Both the column should have the same the value and datatype of the join column.
This will resolved the duplication.
Regards,
Naveed Ali
Hi @liya101 , I am marking this reply as, “Solution,” in case you need further assistance with your problem, please create a sample dashboard with sample dataset showing your problem state using Arena and please create a new post, so we can look at it from a fresh perspective. (Details on using Arena can be found here - QuickSight Arena)
