Use RangeSum and don't count duplicates

[MRitter]

I have a line chart that has the following metric:

Rangesum( Above(Count
(Distinct {<ControlorMail={'C'},TotRetailQuantity = {">=1"},transaction_dt = {">=$(=CampaignStartDate)<=$(=CampaignEndDate)"}>} brand_customer_id)
, 0, RowNo()))

The dimension is the transaction_dt.

Works great except when I have a customer who shops on multiple dates.  I only want to count them one time.  But currently I am counting them each time.  

Not sure what modification I need to the above to only count them a single time?

[sunny_talwar · Accepted solution]

What is your dimension? date or as of date? Make sure it is as of date field

[MRitter]

I thought about that and changed it.  I also changed the customer_id to match the field name in the transaction file.

That seemed to do the trick.

Thank you so much for your help.