Last record for latest timestamo

[kavieweg]

Hi togehter,

i would like to have the latest (eventtype and Kee) for the latest timestamp of the selected Customer

Customer	ValDepot	Kee	timestamp	eventtype
A	0406	39144	1.522.783.109.000,00	6
A	0406	39143	1.522.782.099.000,00	5
A	0406	39084	1.522.763.602.000,00	4
A	0406	39060	1.522.754.579.000,00	3
A	0406	38663	1.522.199.638.000,00	10
B	0406	38556	1.522.163.379.000,00	6
B	0406	38544	1.522.161.117.000,00	5
B	0406	38462	1.522.131.967.000,00	4
B	0406	38454	1.522.129.900.000,00	3
B	0406	38207	1.521.816.258.000,00	4
C	0406	38193	1.521.811.602.000,00	3
C	0406	38180	1.521.805.247.000,00	6
C	0406	38170	1.521.801.280.000,00	5
C	0406	37564	1.521.723.207.000,00	4
C	0406	37558	1.521.720.757.000,00	3

Thanks for help

Mathias

[sunny_talwar]

You need to do this in the script or front end?

[kavieweg]

Hi Sunny,

in the first Version in the front end. But I am interested in both possible solutins.

Thank you in advance.

Mathias

[sunny_talwar]

May be try this

FirstSortedValue(Kee, -timestamp)

FirstSortedValue(eventtype, -timestamp)

[kavieweg]

- this does not work. I Need the value e.g. eventtyp, for a selected customer.

So from a customer (here i have multiple entries for one Customer) the eventtyp of the latest record (timestamp)

[sunny_talwar]

I can show you what I mean by creating a sample, but I don't really understand your date field?... what kind of format is this?

1.522.783.109.000,00

[kavieweg]

milliseconds since 1970 🙂

Current Millis ‐ Milliseconds since Unix Epoch

[kavieweg]

milliseconds since 1970 🙂

[kavieweg]

1522783109000

[sunny_talwar]

Is this what you wanted?