I’m trying to do something that I thought would be pretty simple to do but having looked into it, the documentation is pretty impenetrable in places, it looks like I may be able to do what I want with one of these approaches but I’m not sure.
What I’m trying to achieve is retrieving the number of mobile device users who have visited a specific URL (which indicats when the user has access the edit page of a CMS.) in the last year; yes we’ve archived all but the last month’s worth of data.
What it looks like is that I’d need to do is to use the pivotBy but I’m not sure if this is actually the right approach to take.
Any help would be much appreciated.