I have several years of data with thousands of clients each. How can I create a set/chart/expression that will list the recurring clients if there are any? Thank you!
You need to do this in the script of course. I would say after you have loaded in the client table, make a new table, group by client_id, then code if (count(purchase#) > 1, 1, 0) as RepeatCustomerFlag. In this example, you would be tracking whether a customer has more than 1 purchase number, and if so, he is a repeat customer. Then, in your chart, you could use set the dimension to something like this: if(RepeatCustomerFlag=1,client_id) and suppress nulls.
You need to do this in the script of course. I would say after you have loaded in the client table, make a new table, group by client_id, then code if (count(purchase#) > 1, 1, 0) as RepeatCustomerFlag. In this example, you would be tracking whether a customer has more than 1 purchase number, and if so, he is a repeat customer. Then, in your chart, you could use set the dimension to something like this: if(RepeatCustomerFlag=1,client_id) and suppress nulls.
