How to report on only one option of a dropdown

[DBerg35]

I am trying to create a report on attendance for my company’s webinars. I would like it to be a table that shows each Webinar Date, the number of people who registered and the number of people who attended.

I can not figure out how to show both number of registrations and number of attendees. Filters can show me only the Number of Attendees, but that filters out all Registrations except those who attended. If I add Number of Attendees to my columns, it creates multiple lines for the same date
Ex.

Webinar - # of registered - # of attended

Webinar 1 - 15 - Attended

Webinar 1 - 5 - (no value)

Webinar 1 - 10 - Did Not Attend

Webinar 2 - 21 - Attended

Webinar 2 - 3 - (no value)

Webinar 2 - 12 - Did Not Attend

Is there a way to filter a single column so that it just tells me the total number of contacts that are Attended=yes?

like this?

Webinar - # of registered - # of attended

Webinar 1 - 30 - 15

Webinar 2 - 36 - 21

[danmoyle]

@DBerg35 instead of that table visulaization option, can you do the pivot table option (two icons to the right) and group them by that property of attended or not? That’s where I’d go with this request.

[DBerg35]

Just tried with the pivot table and I’m not seeing any way of not showing the Did Not Attends and (no value)s.

[danmoyle]

I guess I misunderstood your original question. I read it that you wanted to see the number of attended and did not attend.

Once you have the pivot table, you should be able to add a filter for that property and only show specific choices. That should* clean up your pivot table.

*Should because I don’t have this specific property in my own portal, so I’d only be using a similar one, which isn’t exactly the same. But that would be expected behavior in my experience.