topic Association between 2 products in App Development

Association between 2 products

danimarc12 — Sat, 20 May 2023 12:33:01 GMT

Hello everyone!

I have an issue with an expression. This is my pivot table where I have the dimension reparto in the rows and reparto2 in the columns:

I have used the following expression: count (distinct scontrino) to calculate the number of order with both of the products.

My goal is to display a value which divides this number by the total of order for each product. This total is the number underlined. So I want to display in order:

BARBERIA: (91/91 ) 100% | (1/91) 1.09% | (2/91) 2.19%....
DESIGN: (1/401) 0.25% | (401/401) 100% | (1/401) 0.25%.....

Could anyone help me to write the correct expression to achieve my goal?

Thank you so much!

Re: Association between 2 products

Kushal_Chawda — Sat, 20 May 2023 22:50:27 GMT

@danimarc12 try below

count (distinct scontrino) / count(total <reparto>{<scontrino={"=reparto=reparto2"}>} distinct scontrino) or count (distinct scontrino) / count(distinct total <reparto>if(reparto=reparto2,scontrino))

Re: Association between 2 products

danimarc12 — Sun, 21 May 2023 15:20:06 GMT

Hi @Kushal_Chawda ,

thanks for your answer. It still not working ☹️ This is the result:

Re: Association between 2 products

Kushal_Chawda — Sun, 21 May 2023 21:48:32 GMT

@danimarc12 which expression you are using. make sure that field names are correct in your expression

Re: Association between 2 products

danimarc12 — Mon, 22 May 2023 15:43:47 GMT

Hi @Kushal_Chawda , I've used both of the expressions.

First expression:

Result:

Second Expression:

Result: