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.

Outcomes