topic Re: Aggr Sum Distinct clause in App Development

Aggr Sum Distinct clause

klikgevoel — Sat, 16 Nov 2024 20:51:52 GMT

Hi all,

Assume the following arbitrary dataset:

success_login, personid

1, P1

0, P1

1, P2

0, P2

What I want is to use a solid statement that calculates the aggregated sum over success_login. As such, the end result would be this

success_login, personid, logins

1,P1,3

1,P2,1

I already tried it with =Aggr(Sum(success_login), personid). Which doesn't filter out the zeros (0). Using set analysis

=Aggr(Sum({1<success_login={1}>}), personid) gives me blank output.

What's wrong with my approach?

Re: Aggr Sum Distinct clause

sunny_talwar — Wed, 15 May 2019 13:42:57 GMT

Why don't you just do that

Dimensions

sucess_login person_id

Expression

Sum(success_login)

Re: Aggr Sum Distinct clause

dplr-rn — Wed, 15 May 2019 13:47:06 GMT

Why do you need aggr there.
below expression will work for what you have shown above
Sum({<success_login={1}>}success_login)

Re: Aggr Sum Distinct clause

klikgevoel — Wed, 15 May 2019 14:40:05 GMT

Apparently the answer is not so trivial in my situation due to the underlying data model. Second, apparently I had to employ some extra dimensions in my Table to get the actual values to appear.

Re: Aggr Sum Distinct clause

dplr-rn — Wed, 15 May 2019 14:41:48 GMT

Share details of the problem with appropriate sample data and we can try to help

Re: Aggr Sum Distinct clause

jwang2016 — Wed, 15 May 2019 14:52:44 GMT

try to use count({<success_login={1}>})personid).