R
Robin
I have a sheet of data pulled from Remedy (40,000 rows, 3 columns). Each
record is created with date and time, user group and user. I created a pivot
table to get a total count of records assigned to each individual, however, I
would like to break it down even further, by doing a weekly count of records
assigned to the individual. I removed the time from the field and left with
the day, such as Jan 1, Jan 2.
Is there someway to convert the day field and combine them into weekly
groups to pull a total count by individual, per week, starting Jan. 1 to
present day?
record is created with date and time, user group and user. I created a pivot
table to get a total count of records assigned to each individual, however, I
would like to break it down even further, by doing a weekly count of records
assigned to the individual. I removed the time from the field and left with
the day, such as Jan 1, Jan 2.
Is there someway to convert the day field and combine them into weekly
groups to pull a total count by individual, per week, starting Jan. 1 to
present day?