Filter on employee locations for a historic date

I needed a list of employees based in each of our office locations as at a historic date. There's no way of doing this under the current query filter options so it would be great for this to be added.

Describe the Challenge

Improved historic data reporting