topic Percentage by cat by month in App Development

Percentage by cat by month

Tenuki — Tue, 29 Jul 2025 13:30:40 GMT

Hello,

I would to show the distinct number of customer by a category of product, for 2 categories, and have it by month.

So far I have :

The distinct id for both cat with

Count(DISTINCT {<CatProductID= {'Mycat1'}>} ID_Client)

Count(DISTINCT {<CatProductID= {'Mycat2'}>} ID_Client)

But when I try to find the percentage of client by month, I get the percentage of total client of the cat global, not for the month.

I try this :
Count(DISTINCT {<CatProductID= {'Mycat1'}>} ID_Client) / (Count(DISTINCT {<CatProductID= {'Mycat1','Mycat2'}>} TOTAL {<MonthName>} ID_Client))

Maybe TOTAL need to be change ?

Thanks for your help

Re: Percentage by cat by month

Tenuki — Tue, 29 Jul 2025 13:38:43 GMT

I found my error

Correction :

Count(DISTINCT {<CatProductID= {'Mycat1'}>} ID_Client) /

(Count(DISTINCT {<CatProductID= {'Mycat1','Mycat2'}>} ID_Client))

But I have some client that buy both of my cat on the same month. So my percentage isn't right.

Is there a way to work on this issue ?

Re: Percentage by cat by month

marcus_sommer — Wed, 30 Jul 2025 11:57:04 GMT

It depends always on which kind of rate should be calculated. Maybe the following are alternatives for your scenario:

rangesum(Count(DISTINCT {<CatProductID= {'Mycat2'}>} ID_Client),
Count(DISTINCT {<CatProductID= {'Mycat1'}>} ID_Client))

Count(DISTINCT {<CatProductID= {'Mycat1','Mycat2'}>} ID_Client&CatProductID)

Re: Percentage by cat by month

Tenuki — Wed, 30 Jul 2025 12:10:11 GMT

Thanks, rangesum give me want I expect.