Hi everyone, I need some help on the following scenario… thanks in advance.
Based on the relationship of the collections above, I need to count the number of offices a user has visited within inclusive dates. For example…
user visits 10 offices over a period of 1 year.
user visits the some offices more than 1 time in same year.
I want to count the number of offices the user visited for that year but only count an office 1 time even if the user visited that office multiple times.
So at a max count if the user visited all the offices multiple times, I only count a max of 10 offices.
Any tips and/or techniques are greatly appreciated.
Thanks!