Line chart as a timeline
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?