Archive

How to sum of distinct count of different fields?

New Member

I need to sum of distinct count(emal_id) if event_name=email and distinct_count(person_id) if event_name=push. And sum of these distinct count need to be in one field.

Please suggest.

Any help would be highly appreciated.

0 Karma

Motivator

| eval dc_email_id=if(event_name=="email",somefield1,0)
| eval dc_persion_id=if(event_name="push",somefield2,0)
| stats dc(dc_email_id) as emailID,dc(dc_person_id) as personID by event_name| eval somefield_name = emailID + personID

0 Karma