I would like to display the count of new Customers, displaying the amount over time in a graph or chart. The problem is that there is no data regarding the date a Customer was created. Therefore I would like to make an expression that counts the amount of customers that have been counted before. I want to show it with time as the dimension, so that I can see from one month to another how many new customers I have.
count ( if ( Customer has not already been counted , Customer ) )
Is this possible? If so, any help will be welcome.
Indeed I thought of counting customers by the first time they make a purchase, but I have a problem trying to doing that. The data I have is neither from a database, nor any files, so I don't use Load or SQL-queries to load the data. I load the data using:
Loading data like this is not by choice, and I have no other option. Is there still a way to create new fields and such?