Google Spreadsheet Post #1123
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Apr 14, 2013
user Macarse :(http://productforums.google.com/forum/?zx=yg5pzs6aeocd#!category-topic/docs/spreadsheets/7wK9_151FEI)
How to create something like a cumulative date graph
Hello,
I have a column with different dates from events.
Example:
11-Apr-2013 23:08:09
11-Apr-2013 23:08:46
11-Apr-2013 23:09:38
11-Apr-2013 23:10:42
11-Apr-2013 23:10:54
I want to analyse at what time most of the events were generated.
I was thinking of doing something like counting the amount of events per minute.
With the sample data the graph should say:
11-Apr-2013 23:08 => 2
11-Apr-2013 23:09 => 1
11-Apr-2013 23:10 => 2
Any idea of how it?
Thanks
---------------------------------------------------------------------------------------------------------
following is solution to a bit more generalized problem
No comments:
Post a Comment