First occurrence of a record

Question

Hi

I have a list of contacts who registered for a few webinars, my requirement is to get the number of contacts registered by Webinar considering only the first occurrence, irrespective of other webinars registered.

So if a contact registers for 3 webinars, he has to appear only under the first webinar he registered and not under others.

The output should look something like this:

Webinar#ContactsWebinar12Webinar2 5Webinar31

Attached a sample file.

Tableau Community Forums Member (Inactive) · Accepted Answer

Hi Naveen

I used your calculation with a slight change, since i wanted the calculation not based on Webinar name but Webinar date,

if {FIXED [email]: MIN([date of webinar])} = [data of webinar] THEN [email] ELSE NULL end

Naveen Reddy · Answer

Hi Anusha,   Create a calculated field like below     Drag Webinar to rows and Min Webinar --> Text --> Measure --> Count distinct you will get the required O/P     hope this helps Plz mark this answer as correct or helpful to close the thread   BR, NB

First occurrence of a record

Contacts

Verwandte Lerninhalte

Weitere Hilfe