Chart question

[dloomis]

I have a table called Date Items that includes a field called Dates. I want to create a chart that uses the values of Dates as the X axis, and then the number of days between records as the Y axis. So, if there are 3 records: 1/1/12, 1/10/12, and 1/21/12, the chart would show three entries. The first date would have no Y value, but the next two would have 9 and 11 as their Y axis values. Is this possible? Thanks.

[JerrySalem]

Sounds like you want to use a Scatter chart

[comment]

I have a table called Date Items that includes a field called Dates. I want to create a chart that uses the values of Dates as the X axis, and then the number of days between records as the Y axis. So, if there are 3 records: 1/1/12, 1/10/12, and 1/21/12, the chart would show three entries. The first date would have no Y value, but the next two would have 9 and 11 as their Y axis values. Is this possible? Thanks.

It's possible, if you let each record calculate the number of days elapsed since the previous record, and use the result as the Y axis value.

The calculation itself can use the GetNthRecord() function, or a running summary field or - if you prefer to ignore the found set - a relationship to retrieve the previous record's date.