Hello All.

I managed so far to install Palo, modelize a database, import data and generate nice reports with Palo.

However I'm stuck with an issue that could anihilate all these efforts.

How to count the number of clients buying a certain type of product for a certain period of time. I will give you a very simplified example:

You have 3 customers: A, B and C.

you have 4 products with 2 family: Fam1 with products P1 and P2 and Fam2 with products P3 and P4.

Let say customer A bought 3 P1 and 4 P3.

Customer B 5 P2

Customer C 6 P1, 2 P2, 8 P3 and 1 P4.

Therefore you will agree that 2 distinct customers bought P1 and 2 distinct customers bought P2.

But only 3 distinct customers bought products of family Fam1!

In other words the consolidation rule is not 2+2 = 4. but 2+2 =

Of course we could make the same example with the time dimension:

3 active customers in month1, 4 in month 2 but total month1 + month2 is 5 and not 7 since two customers who bought in month 1 also bought in month 2.

How can we do that in Palo??

someone else must have had to deal with this kind of issue.

Counting the number of active customers, new customers, lost customers, conquered customers etc. is a classic and very important KPI for many businesses.

Thank you for any advice,

Guillaume.

I managed so far to install Palo, modelize a database, import data and generate nice reports with Palo.

However I'm stuck with an issue that could anihilate all these efforts.

How to count the number of clients buying a certain type of product for a certain period of time. I will give you a very simplified example:

You have 3 customers: A, B and C.

you have 4 products with 2 family: Fam1 with products P1 and P2 and Fam2 with products P3 and P4.

Let say customer A bought 3 P1 and 4 P3.

Customer B 5 P2

Customer C 6 P1, 2 P2, 8 P3 and 1 P4.

Therefore you will agree that 2 distinct customers bought P1 and 2 distinct customers bought P2.

But only 3 distinct customers bought products of family Fam1!

In other words the consolidation rule is not 2+2 = 4. but 2+2 =

**3**because customer C bought P1**AND**P2.Of course we could make the same example with the time dimension:

3 active customers in month1, 4 in month 2 but total month1 + month2 is 5 and not 7 since two customers who bought in month 1 also bought in month 2.

How can we do that in Palo??

someone else must have had to deal with this kind of issue.

Counting the number of active customers, new customers, lost customers, conquered customers etc. is a classic and very important KPI for many businesses.

Thank you for any advice,

Guillaume.

The post was edited 1 time, last by gilberto ().