Set Analysis Question

NevoPotok — Sat, 16 Nov 2024 05:43:52 GMT

Hi,

I have a model which display feature usage and I want to display only accounts that use specific feature more than X (variable) time.

I tried to use this exp. but it didn't work:

sum( {$<AccountID = P({<"=Sum(Aggr(Sum(Usage),AccountID,FeatureID))={>$(X)"} >})>} Usage )

Explanation: return only the AccountID the sum of the usage by FeatureID is greater than X, and only for those AccountID to Sum the Usage.

Appreciate any assistance

Re: Set Analysis Question

NevoPotok — Mon, 27 May 2019 19:38:57 GMT

@sunny_talwar @swuehl really appreciate if one of you can assist with this issue

Thanks