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]

Fixed the calculation for DateandTime (not that it matters)

[kavieweg]

Yes 🙂

[kavieweg]

Hi Sunny, this worked. but not if I want the result (e.g.event ) in a KPI

[sunny_talwar]

This should still work when a single Customer is selected in a KPI object... what would you want to see when there are multiple Customers?

[kavieweg]

Yes. I forgot to say this 😞 - I need one result for each customer (yes I have multiple customer 🙂 - I will modify my data table.

[sunny_talwar]

What do you want the KPI to show when no Customer is selected?

[kavieweg]

Nothing 🙂

Can you also link Customer and ValDepot as unique?

Because I can also have customer A in ValDepot 0420 eg. 🙂

[sunny_talwar]

I understand what you mean, but I am not sure I understand the outputs you are expecting to see in various scenarios. It would help if you can be very specific

[kavieweg]

🙂

I want the eventtyp and the kee for each customer (and later in each ValDepot) but only of the latest timestamp

🙂

A

0406

39144

1.522.783.109.000,00

6

B

0406

38556

1.522.163.379.000,00

6

C

0406

38193

1.521.811.602.000,00

3

[sunny_talwar]

In a KPI? or in a chart? If this is in a chart... my expression above still stay the same... if this is in a KPI... I am not sure how you want to show this much information in a KPI object... if you have 1000 customers, you would want the KPI to show all 1000? Will be very user unfriendly, but if that is what want, You just need to add Concat(Aggr(Expression, Customer), Chr(10)) to show that