Inter record function in a chart

[#1]

Hi

I need to calculate the Next Date and Previous date based on the Product selection. I need this on the chart expression not in the script. Thanks for the help.

GpID	ID	Date	Product
123	12345	1/1/2012	Public
123	12346	1/5/2012	Public
123	12347	1/9/2012	Private
123	12348	1/13/2012	Public
123	12349	1/17/2012	Private
123	12350	1/21/2012	Private
123	12351	1/25/2012	Public
123	12352	1/29/2012	Public

[Clever_Anjos]

Please check Before() function into your help/manual

[sunny_talwar · Accepted solution]

Something like this?