AnsweredAssumed Answered

charting records on a timeline

Question asked by mr.fixit on Sep 26, 2012
Latest reply on Sep 28, 2012 by mr.fixit

I have a DB where every record is an "event" and the date-time of the event is in a timestamp field.


I want to graph the events on a timeline, to give a sense of when the events occured, their frequency, etc.


The best I've come up with so far is to create a 2nd calculated field, 'day', = timestamp / 86400 + 1. A third field is 'day_count', a summary field = 'count of day'. I sort by 'day', put the 'day_count' in a sub-summary field, and create a chart with X='day' and Y='day_count'. I then get the following:



This isn't great because it doesn't convey the elapsed time between the events. I want the x axis to be a timeline, so the distance in time between the events would be proportional to the distance in the x-coordinate.


I imagine this is a FAQ, but I can't find it.


All pearls gratefully accepted.