Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a case and I need your help!
I want and mode in set analysis too but I don't want user make any selection.
I need to count all customer's that own both car and boat and the boat is A.
Please advice.
Thanks in advance,
Eleni !
What is the expected output here?
Hi Sunny,
There are a lot of things!
A table with all customers owns both car and boat and the boat is A, per Sales Channel.
See the refreshed app.
Regards,
Eleni
Привет Элени,
Concat (Aggr (только ({<Customer = { "= Aggr (Count (Заказчик), Заказчик) = 2"}, {Пункт = 'A'}>} Заказчик), Заказчик), ',')
Смотри прикрепленный файл.
С Уважением,
Андрей
Hi Andrey,
Thanks a lot for your reply and sample.
Due to my bad Russian I would prefer to communicate in English if it's ok for you as well!
Your sample is close enough but I need the customer count, not the actual values, I have try to convert your expression but there is always an error....
Regards,
Eleni
Hi Eleni,
Maybe You can try the following:
count(Distinct {<HaveCarFlag ={'1'}, HaveBoatFlag={'1'}, SalesChannel = {"=count(Distinct CustomerID)"}>} CustomerID)
and for the filters you do not want to work with the user selections, just add them into the set analysis like this:
Filter1=, Filter2= and so on.
Hope that helps,
Carlos M