May 10 2019
06:19 AM
- last edited on
Jul 12 2019
11:24 AM
by
TechCommunityAP
May 10 2019
06:19 AM
- last edited on
Jul 12 2019
11:24 AM
by
TechCommunityAP
Hello,
I am working with a very large dataset, 94,000 rows. Each row is a specific action per client and the time stamp. For example:
Client Name Location Action Date&Time
AA Wing A Change 05/10/2019 0800
AA Wing A Stop 05/10/2019 0815
AB Wing B Change 05/10/2019 0700
What I want to do is summarize for each client
(1) how many changes occurred in a given time period
(2) How many clients had changes in less than 1 hour
(3) I would like to graph this globally and per location
Is there a way to do this with Pivot tables or should I create another sheet and column to extract this information?
Thank you!
May 13 2019 05:03 AM
I'd recommend you split out your date and time into 2 columns and then a Pivot Table be able to give you the results you need
May 13 2019 05:17 AM
May 13 2019 05:17 AM