In the 10,945 rows of QUOTE_ID there are no duplicate records. Where is the duplication coming from? Please demonstrate/explain how you're getting a wrong count. Please add the the win/loss ration to the viz so I can see how you're wanting to use it. Thanks,
Ryan, T is giving you 2% (actually 2.38%) because that's what 1 win divided by 42 records equals. You haven't told T that you only want to count unique Quote_ID records, so T is giving you this:
To fix this all you have to do is change your denominator from counting records to counting unique IDs like this:
This produces the 3.45% you're looking for.
Shawn, that's twice you've saved my bacon now. Thanks for giving this rookie some tips and tricks!
Happy to help. Always nice to hear a bit of encouragement, thanks.