Sunday, April 14, 2013

yogi_From Timestamp Column Get Count Of Transaction By TimestampMinute And By The Minute


                                          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