topic Re: And mode in set analysis in App Development

And mode in set analysis

eleni_theodorid — Thu, 23 Mar 2017 18:59:48 GMT

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 !

Re: And mode in set analysis

sunny_talwar — Thu, 23 Mar 2017 19:10:00 GMT

What is the expected output here?

Re: And mode in set analysis

eleni_theodorid — Thu, 23 Mar 2017 19:20:39 GMT

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

Re: And mode in set analysis

ahaahaaha — Mon, 27 Mar 2017 06:42:49 GMT

Привет Элени,

Concat (Aggr (только ({<Customer = { "= Aggr (Count (Заказчик), Заказчик) = 2"}, {Пункт = 'A'}>} Заказчик), Заказчик), ',')

Смотри прикрепленный файл.

С Уважением,

Андрей

Re: And mode in set analysis

eleni_theodorid — Mon, 27 Mar 2017 14:34:49 GMT

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

Re: And mode in set analysis

CarlosAMonroy — Mon, 27 Mar 2017 15:14:55 GMT

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