-
1. Re: Total repeat customers, multiple merchants with FIXED calc
Derrick Austin May 19, 2016 2:04 PM (in response to Sarah Arnio)1 of 1 people found this helpfulHey Sarah,
If I am understanding your requirements correctly, you are very, very close with the calculated field.
Two things:
1) Move the >1 logic outside the FIXED calc.
2) Add Application Code to the FIXED portion.
Hope this helps!
IF {FIXED [buyer_email], [Application Code] : COUNTD([product_description])} > 1 THEN [buyer_email]
END
-
2. Re: Total repeat customers, multiple merchants with FIXED calc
Sarah Arnio May 20, 2016 11:16 AM (in response to Derrick Austin)Thank you so much Derrick, looks like this worked!
-
3. Re: Total repeat customers, multiple merchants with FIXED calc
Sarah Arnio May 20, 2016 12:11 PM (in response to Derrick Austin)Hi Derrick,
So when I look at the emails individually, this new calculation works, however now I want to know the count of this Repeat cust (other merchants). When I display the data individually and count them up, I get 60 customers. But when I do a COUNT measure in the shelf on this field (without changing/adding anything else), it shows me 2344. I'm not sure why this is happening, I even excluded NULL values. Attaching a screenshot here.
Thanks!
-
4. Re: Total repeat customers, multiple merchants with FIXED calc
Derrick Austin May 20, 2016 12:15 PM (in response to Sarah Arnio) -
5. Re: Total repeat customers, multiple merchants with FIXED calc
Sarah Arnio May 20, 2016 12:17 PM (in response to Derrick Austin)Ha, you're right! Should have tested that first. Thanks for the quick response.