SQL and/or LINQ query for determining daily increases in viewers
- by Gio
We're montioring usage of a certain resources by monitoring users logins (We can see user logins growing daily). After filtering out repeat inter day logins for users, we'd like to track the # of users using the service each day, and then using that info to determine overall incremental gains for each calendar day. Our table is pretty simple:
class ServiceLogin
{
String login;
DateTime loginTime;
}