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    Apr 14, 2013
user Macarse  :(!category-topic/docs/spreadsheets/7wK9_151FEI)
How to create something like a cumulative date graph

I have a column with different dates from events.

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?

following is solution to a bit more generalized problem