For loop on each result of a the table

[giolapid911]

I have query that  returns successful logins and a profile ID.

Then from the result of those I want to create another search for each result that shows the email address of the the profile ID.

First query is 

index=commerce loginSuccessful=true
| stats count by profile

Then I would want to do the following.

For each "profile"

index=commerce "profile email!="<null>" email!=null | table profile email 

[johnhuang]

index=commerce ((loginSuccessful=true) OR ("profile email!="<null>" AND email!=null))
| eval login_ct=CASE(loginSuccessful="true", 1)
| stats sum(login_ct) AS login_ct BY profile email