Title
Line chart as a timeline
Post
I was reading a basic description of how a line chart can be formatted as a timeline.
It requires the use of a 'dummy table', with one record created for a date within the date range. In this table, there is a calculated field showing the date fields that have records for specific dates, which then become the timeline's milestones, appearing on the relevant day. It is the calculated filed that becomes the X axis.
Does anyone know how the 'dummy table' is created, and how records are created within this table for each day within the date range?
I would suggest you create 30 records in the table (to make a month of days). Set a script to show all records, and Replace Field Contents or loop through the records setting each to be the next sequential day, after a user-specified start date, say.
So for a month you have one record per day.
Create a relationship from that table to the data source table, linking date to date. Presumably you have a value in the source table that is the total or whatever by day that you want to plot.
In the 'dummy' table create a field 'YValue', = the value in the source table you are trying to plot, using that relationship.
You can now draw a chart with the date on the x-axis and that value on the y.