Using a Set expression with AGGR function

Anonymous — Mon, 28 Aug 2017 13:11:19 GMT

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

Re: Using a Set expression with AGGR function

sunny_talwar — Mon, 28 Aug 2017 13:18:46 GMT

May be this

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

Anonymous — Mon, 28 Aug 2017 13:23:06 GMT

Thank you very much Sunny!!