Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All ,
Need help on set expression with following scenarios .
1) How to Find Number of Customers who Did not Purchase any Item in Year 2015 ?
2) How to Find Number of Customers who Did not Purchase any Item in Year 2015 But have Done Purchase in Year 2016 ?
3) How to Find Customer who Purchased More Number of Items ?
4) How to Find Customer who Purchased More TYPES of Items ?
5) How to Find Number of Customers who have Purchased more than one type of Item in Year 2015 ?
6) How to show item least purchased ?
Also Find sample Attached .
Thanks & Regards
Shekar
In a single set analysis... may be like this
=Count(DISTINCT {< Customer = {"=Count({<YearIS = {2015}>} Item) = 0 and Count({<YearIS = {2016}>} Item)>0"}>} Customer)
Please help stalwar1
Look here at vinieme12 and my responses
Nested Set Analysis - Customer bought in both time periods
Specifically for your sample, it might be helpful for us to know what are the expected output for all of the question listed above...
or if someone else have free time... they might be able to give it a try
Thanks for reply .. I thought you have taken sabbatical or something ...
Will be available on and off
I got most of it .. I request if you can help me on this .
How to Find Number of Customers who Did not Purchase any Item in Year 2015 ?
like below
count({<Customer = {"=Count({<Year={2016}>} Item)=0"}>}Distinct Customer)
May be this if you don't have year field.... but recommed creating year field in the script.....
=Count(DISTINCT {<Customer = {"=Count({<Date = {""=Year(Only({<Date>} Date)) = 2015""}>}Item) = 0"}, Date>} Customer)
I am getting error for following
Number of Customers who Did not Purchase any Item in Year 2015 But have Done Purchase in Year 2016