3 Replies Latest reply on Aug 30, 2018 6:57 AM by Love Tableau

# Meeting Attendance Metrics Ideas

Hey everyone,

I was given a very large data set initially, so I've created a smaller dummy data set for the purposes of this thread.

So the data set that I have basically consists of a list of people, meeting types, a date for that meeting with the format of month/year, and two columns indicating an invite sent out and whether the person actually attended the meeting (I will attach the data set along with this, so I hope it can be more clear). So the idea is to basically calculate the percentage attendance of people attending meetings, and then being able to visualize that and see trends in attendance.

Here's a screenshot of the data set. For the invites column, a 0 indicates that an invite was not sent out, and a 1 indicates that it was. For the attendance column, a 0 indicates that the person did not attend that meeting, and a 1 indicates that they did. These numbers aren't booleans, but are just normal numbers which can be used in aggregations and all.

Here's a screenshot of the dashboard. The percentages charts are made from calculated fields that I created (I'll attached the packaged workbook as well so you all can take a look).

The one thing that I want to do is be able to look at trends in % attendance for each meeting type over time. The thing is, I haven't been able to come up with a way to do so given the way the data is currently prepped. I'm hoping to see something like a line chart with the trends in percentages. I was hoping to get more ideas on how I could do that, and integrate it with what I currently have.

Please let me know if you have any questions about this! It might be a bit confusing to understand at first. I'm using Tableau 2018.1 for this.

• ###### 1. Re: Meeting Attendance Metrics Ideas

Hi Abhi,

I tried to combine the date values at the Datasource tab by holding Sep,oct and Nov fields and named it as Date.

As there are same values for each meeting type there isn't much you can do with line graph. If you ask me I just stick with the bar graphs you have in the workbook. Below is the screenshot fo line graph and data showing the measure values

1 of 1 people found this helpful
• ###### 2. Re: Meeting Attendance Metrics Ideas

Hi,

This might actually work. Like I said, this is just a dummy data set, so we might be able to use the line chart with the larger data set. Thanks for your help!

Also, do you think there's a better way I can prep the excel data set before connecting to Tableau? Maybe a way which makes it easier for me to see trends?

• ###### 3. Re: Meeting Attendance Metrics Ideas

Abhi,

Kindly go through this article which helps you understand how to clean your data easily with DataPrep previously called as 'Project Mastro'.