Classic Search

hvfalcao · ‎2015-09-18

Hi! I'm struggling to find a solution to count new/lost/returning/loyal customer over the years... I've tried different approaches posted on the community (script and expression), but couldn't r...

madhuqliklondon · ‎2018-07-12

Hi All, I want to find total inactive customers for last 12 months on month basis which means they have placed order before 12 months back and became in active. So want calculate this every month b...

tmumaw · ‎2017-10-30

Good morning, I need a little help finding current, new and lost customers. The first part of the script finding old customer and new customers seems to work, but the lost customers I am h...

customer count, new,lost, total · ‎2013-10-13

I have the following logic to calculate Lost Customer - hasn't bought anything the last two years New Customer - bought something this year, but nothing the last two years Total Customers - e...

renjithpl · ‎2012-08-28

Hi All, I am trying to find Lost, New and Loyal customers month wise. User will select year and a month, a pivot table should show the count of the customers lost in current month, new customers...

Calculate new and lost customers · ‎2010-02-26

Hello everybody! Is there an elegant way to state how many customers we have gained in a given year compared to the previour year? In the attached example Tom is a loyal customer, Jim is a new one a...

How to Get New and Lost Customers · ‎2012-09-25

Hi, I would like to get the list of new, kept and lost customers in different text boxes. Data set: Sales: LOAD * INLINE [ Year, Customer, Sales 2...

1 Like · ‎2011-11-28

...egarding lost customers and set analysis, and I have to saythat for a newbie the SET Analysis is very complicated. After several days, I have prepared the following expressions that give me a very g...

Anonymous · ‎2018-07-22

Hi, I have a query where I need to find out new and lost customers monthly. New - A customer which did not have a record in last month sales data. Lost - A customer which had a record in l...

rwunderlich · ‎2010-12-13

I'm working on the classic new/lost customer problem using set analysis. I've found a few examples on the forum, but they don't seem to fit exactly what I'm after. I'm using the AsOf table approach w...

Classic Search

Search

Search the Community

New/Lost/Returning/Loyal Customers

Lost/Inactive customers

Current, New and Lost Customers

customer count, new,lost, total

Lost, New and Loyal Customers month wise

Calculate new and lost customers

How to Get New and Lost Customers

Lost Customers using Set Analysis & Rolling Period...

Calculate New & Lost Customers

New customer analysis using set analysis