Forum Discussion
Help with Running Total
Hi, so I need to calculate the number of users based on 5 criterias: the customer, the user id, server name, login date and finally login time. So for example, I want to know how many users logged o...
this is the type of data but I can't reveal the real data so basically there will be many users id as well and I am guessing that is how we will group the data by in additition to looking at these fields. any help is appreciated.
Just a few questions. Let's take your first row of your desired output where it is 4. Customer, server, login date and login time are the columns you want to get the count for, correct?
Assuming that is true, what does that 4 represent? The number of users for customer, server and date, but not 100% clear on the ling time. Would that be distinct count of users that have logged in between 6:00pm and 6:30pm? I'm also assuming that the number of users = 4 would reference more than the data you have above?