Forum Discussion
Calculating Percentage Between 2 tables
Hi..Thank you. I still don't think we are on the same page so I stepped away to think about this a bit more.
I don't care where the course was held (because it was online) or what day it was held). In aggregate, I need a total number of employees who attended classes vs total number of employees. Period. The division is a piece of metadata attached to the employee and it's the same across both tables. So if I have 2 attendees from Ohio, 2 from Alabama and 2 from Nevada for a total of 6 attendees, then I have 10 total employees from Ohio, 14 from Alabama, and 6 from Nevada, my percentages would be 20% Ohio (2/10), 14% Alabama (2/14), 33.3% Nevada (2/6). If I'm not making sense, should I just start over?
Thank you!
Either I'm being really obtuse or I'm completely misunderstanding your scenario. You say location is irrelevant, but then say "I have 2 attendees from Ohio, 2 from Alabama and 2 from Nevada for a total of 6 attendees,".
If you only have one course going on, go with the direct division between the DISTINCTCOUNT of the names attending the course over of the SUM of employees by location.
To be able to help further, please provide sample data to work with.
And, regardless, please read this thread:
Thanks!
I was responding to your comment about locations: "Say Today there have been courses in 5 out of 10 locations, but yesterday there were couses in 10 out of 10 locations." When I say that the location is irrelevant, I mean we don't do courses in actual locations. The location is a piece of metadata about the employee and it will be used as a slicer, just like gender could be used, or job title, or something like that. I thought I provided sample data in the beginning of this thread. I can do that again, but I am not allowed to use dropbox on my computer, so that has always proven difficult for me to attach anything to these forums.
You intitally posted images of your data, with which we cannot work unless we manually type in the values into Excel.
If you have sample, non-confidential data, you can copy and paste it into a post.