I have a requirement to calculate whether a user visited a site multiple times, every week this month (so far).
I have data where I count each users visits weekly, and I am able focus the visits down to the sum of visits for each week of the current month.
The problem is I am trying to get to a KPI value that is two for the following data. Users 4 and 15 have used the site multiple times every week this month.
I have attached a document with some attempts at solving this and some mocked up data. Any assistance is appreciated.