I have a dataset that looks like this
What I need to be able to do is to build a query/queries that will provide actionable data showing when multiple users are checking out a secret within a certain time frame.
So if within a single hour, more than one user has checked out a particular secret I need to know the time between when user1 checked out Secret 1 and user 2 checked it out.
I will then create a report that shows the percentage to show the contrast between when this scenario is met against the activity we see on a normal basis.
Any help as to an approach would be much appreciated!