April 5, 201213 yr Newbies 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.
April 11, 201213 yr 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.
Create an account or sign in to comment