Jan 24 2023 04:43 PM
Hello,
I'm trying to set up a chart or graph that will pull names from my table (that will be updated periodically) and display each name beside how many meetings they've been to and what type of meetings they were.
I've written out an example to more clearly see what I am dealing with. If this is possible I would appreciate any suggestions. Thanks!
Date | Time | Location | Participants | Meeting Type |
05/01/2023 | 11:20:00 AM | Room 214 | John, Kelsey, Aron, Garth, Megan, Erin, Rex | Safety |
10/01/2023 | 2:00:00 PM | Room 213 | Mark, Kelsey, Garth, Max, Ginny | Manager |
13/01/2023 | 10:00:00 AM | Room 214 | Aron, Ginny, Max, Rex, Brian, Tracy, Megan, Steve | Safety |
15/01/2023 | 10:30:00 AM | Room 320 | Mark, Kelsey, Brian, Max, Steve, Ginny, Garth, Erin, Brian, John | Sales |
16/01/2023 | 4:00:00 PM | Room 213 | Mark, Kelsey, John, Garth, Max, Ginny | Manager |
23/01/2023 | 1:30:00 PM | Room 213 | Malcom, Max, John, Rex, Megan, Steve, Timmothy, Sam, Kelsey | Safety |
Jan 24 2023 09:47 PM
Hello @HS113,
I've made a sample, and I think there maybe still some improvement here... but still it'll do what you're looking for...
Sample file is on the attached.