Forum Discussion
Help with Running Total
Any chance you can load some sample data?
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?