Typical solution is like below.
Duplicate data source with Union (x4)
I don't know how you want to calculate "Risk" factor, but go form here anyways.
If this post helped, please mark my answer as correct / helped not from inbox but from original post.
Shift_Merge_SM_10.5.twbx 21.5 KB
Thank you, Shinichiro! I was having additional trouble with this because I have to use ODATA to connect to a SharePoint list as my source, but I have decided to make a link from to MS Access to the list and use Access as the source. The next thing I need to figure out is how to make sure it updates automatically, or at least on a schedule.