Skip to main content
Parker Lachance 님이 #CRM Configuration에 질문했습니다

I have a dataset that contains leads that were converted into an opportunity, as well as the opportunity details. I want to use the same dataset for both counting the number of unique leads, but also the total amount of opportunities. Unfortunately, in some cases more than one lead gets converted into the same opportunity, causing duplicate opportunity amounts. How do you Amount sum only once per unique opportunityID

답변 1개
  1. 2024년 5월 2일 오후 9:58

    My current solution is to use the row number window function and then sum only those that have a row number of 1. Is there a better way?