1 of 1 people found this helpful
Ulrik, I think we're missing a "Customer" dimension to do this accurately. Right now we can't tell when a customer started buying in any given month, and be able to track what you want.
After that, I think you can use a LOD calc to find each customers min(date)....and use that to label their first month and give you a starting point to count the first 12 months. Something like this...
Its difficult to explain but we are looking to get the total som for "all" customers that signed up in a given month and then keep adding to that ammount when ever a customer returns buys more.
We are using this to see if our google advertisement has been "valid" meaning if we have enough return buisness for a period of 12 month, total sales for all customers that made an account in a given month.
right now the list works and i can go an manually just stop the SQL from importing more than a specefic period, so if i want to see jan 2012 customers first 12 months total i just stop the import at 31DEC 2012
but i would like the list to show me all in the same window without me hving to do that for each one.. (takes time)
So to clearify the "customers_info_date_acount_creaed" put the customer into a group like "JAN 2012" the list now shows me ALL sales from that group up until today
I would like somehow to say "only show for the first 12 month purchases after customers_info_date_acount_creaed and keep it in the correct group -
just not sure how to do it, hopefully this explains it better.
oh and thanx for helping out here
IF INT(DATEDIFF('month',[customers_info_date_account_created],[kobs dato])<= 12)=1 THEN [shipping_quote] ELSE 0 END
I got it after about 200 hours of trying..
anyway it works problem solved thanx
200 hours sounds about right. Glad you figured it out
I am researching and working on that problem for quite some time now until I found your thread. Can you quickly explain what [kobs dato] refers to in your solution? That would actually solve my problem.
Thank you in advance!