Date Difference in Chart

[thomas_skariah]

Hi All,

Can anyone help to provide code for below scenario (refer Date Diff column).

Here I need the date difference of below below date with the above date.

Group	Date	Date Diff
A	1-Jul-17	10.00
A	11-Jul-17	6.00
A	17-Jul-17	2.00
A	19-Jul-17	0.00
B	1-Aug-17	3.00
B	4-Aug-17	9.00
B	13-Aug-17	10.00
B	23-Aug-17	8.00
B	31-Aug-17	0.00
C	1-Jun-17	5.00
C	6-Jun-17	10.00
C	16-Jun-17	3.00
C	19-Jun-17	0.00

Regards,

Tom

[sunny_talwar]

Is this something you need in the script or front end chart?

[arvind_patil]

Dear Thomas,

you can not look forward you may refer this thread.

Peek next value in the row

Thanks,

Arvind Patil

[prma7799]

Like this?

[Anil_Babu_Samineni]

Why every month Last date showing Zero, The user want to close Monthly itself or any other logic ??

[thomas_skariah]

Hi Sunny,

I need it at front end, not at back end.

Regards,

Tom

[sunny_talwar · Accepted solution]

May be this

=Alt(Below(Date) - Date, 0)

[thomas_skariah]

Thanks Sunny!!!

[thomas_skariah]

Hi Sunny,

By adding an additional column the result shows as zero, chk below screenshot.

A	SSS	1-Jul-17	0
A	SSS	11-Jul-17	0
A	SSS	17-Jul-17	0
A	SSS	19-Jul-17	0
B	SSS	1-Aug-17	0
B	SSS	4-Aug-17	0
B	SSS	13-Aug-17	0
B	SSS	23-Aug-17	0
B	SSS	31-Aug-17	0
C	SSS	1-Jun-17	0
C	SSS	6-Jun-17	0
C	SSS	16-Jun-17	0
C	SSS	19-Jun-17	0

Regards,

Tom

[sunny_talwar]

What is the output you want here? May be try this

=Alt(Below(TOTAL Date) - Date, 0)