Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
Assume the following arbitrary dataset:
success_login, personid
1, P1
1, P1
1, P1
0, P1
1, P2
0, 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?
Why don't you just do that
Dimensions
sucess_login
person_id
Expression
Sum(success_login)
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.
try to use count({<success_login={1}>})personid).