How to find customers with no sales
Our user wants to see what customers have not made a purchase in a certain time frame. I have tried show all on the axis options and this seems to mostly work by sorting on the amount to group the zeros together. Have also tried, in case where we have a current year and prior year sorting on the current year amount to gather the zeros together. Are there any other ways to do this?
Thank you
Answers
-
Probably the easiest way to only show customers with values = 0, is combing the "show all" with a filter on your dataview (your amount cube < 0.00000001).
You find more info in the help: Layout Filters
0 -
Hi Peter DeGregorio,
your question goes a bit in the direction of what I asked some time agoHow to filter data with (not)exists? and here's a link to Björn Reuber's reply: https://community.board.com/thread/1552-how-to-filter-data-with-notexists#comment-3416
In essence, you need the 'show all' + a filter that removes all the rows with sales values != 0
BR, Ray
1 -
Also don't forget that we have the Analytical Functions. For example, Recency will tell you how many periods since the last purchase and Dormancy will tell you how many zero periods there were in the time frame that you are considering. You can use the results of these functions to filter the rows if required.
You might argue that Recency in the above example should return '3' - I guess though that the calc is assuming that you are now in Jan 14 though.
2
