using P E for market basket analysis

ilanbaruch — Sat, 16 Nov 2024 18:24:41 GMT

hi all

in my model i transaction table

with fields : id, item, quantity ... etc.

loaded this table again with the fields : id, item_1

so the connection between the main table and the secondary is id.

in UI i want to use an expression to count (id) and sum (quantity) of all other items from the user selection in item_1

any ideas ?

advanced thanks

Re: using P E for market basket analysis

Akhil_Reddy — Sun, 05 Jul 2020 17:45:00 GMT

=count( {< id= e( {<item_1= {'$(=GetFieldSelections(item_1))'} >} ),item_1= >} id)

=sum( {< id= e( {<item_1= {'$(=GetFieldSelections(item_1))'} >} ),item_1= >} quantity)