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.