Hi
I have a lot of data like "list of dates it did not rain in London" and
want to do diagrams that show when something occurs more often than
usual.
I tried assigning a value of 1 to each date and doing subtotals by week.
Unfortunately this kind of histogram will smooth over a significant rise
in density if e.g. Saturday and Tuesday were sunny.
So I calculated in a column how many days ago the last event occured,
which projected over time and inverted kind of works, but breaks down
when the event occurs every third day on average but every day at high
times. The differences are just too small.
What I'd need is something that grows when dates cluster.
And something less annoying than Excel. I looked into R, but dates seem
to be second class citizens there.
--
Tobias Weber
