Set analysis intersection problem

kristof_j — Fri, 28 Jan 2022 08:44:39 GMT

I'm having some problems with set analysis.

In my example I have 2 clients who are identical but the set analysis gives different results. So I'm guessing I'm doing something wrong 🙂

I want to see how many clients jumped from 0 to 1. So client A and B.

I used the following expressions:

count(distinct { <year= {2020}, has_product= {0}> * <year = {2021}, has_product= {1}>} Client)
count(distinct {< Client= P({<year= {2020}, has_product= {0} >} Client) > * < Client= P({<year= {2021}, has_product= {1} >} Client) >} Client)

But for some reason in my model it shows 0 for some clients where it should be 1.

I can't change the model so I need to fix this with an expression.

Any suggestions?

Re: Set analysis intersection problem

MayilVahanan — Fri, 28 Jan 2022 09:43:16 GMT

Try like below

Sum(Aggr(count(Distinct{ <year= {2020}, has_product= {0}>}Client)* Count(Distinct {<year = {2021}, has_product= {1}>} Client), Client))

kristof_j — Fri, 28 Jan 2022 11:00:11 GMT

Thx it works.
I hope it won't affect the performance too much if I write many of these expressions 🙂