Using a Set expression with AGGR function

[Anonymous]

Hi,

I'm trying to generate metric to determine how many times a set of object match/belong to a set of categories, for example:

prodID          category/ies                                                result by product

A                    11493655                                                  1

B                    18340461, 26434083                                2

C                    31152327                                                  1

D                    26434083,18361991, 31152327               3

Total result for the above presented data would be  7

The expression I wrote is:

sum ( aggr (count( {$< category ={11493655, 18340461, 26434083,18361991, 31152327}>} distinct prodID), category)   )

Somehow it is not working at all, if somebody could give it a look and find out the problem I can't I would be thankful!!

Thanks in advence,

Javier

[sunny_talwar · Accepted solution]

May be this

Sum(Aggr(Count({$<category = {'11493655', '18340461', '26434083', '18361991', '31152327'}>} DISTINCT prodID), category, prodID))

[Anonymous]

Thank you very much Sunny!!