How to Get Date and Time from Max Transaction

[d4rlie891]

Hi,

Anybody can help me, how to get Date and Time from Max Transaction?

DAY	TIME	TRX
1	10:00	4
1	10:40	7
1	10:55	10
1	11:30	20
1	16:00	15

Thanks

Darlie

[Gysbert_Wassenaar]

FirstSortedValue(DAY, -TRX)

FirstSortedValue(TIME, -TRX)

[d4rlie891]

Hi Thanks for your Help, Could you please tell me how get the Time from Max Transaction that happen in (time 10:00 - 10:55)

Thanks n Regards

[Gysbert_Wassenaar · Accepted solution]

Maybe like this: FirstSortedValue({<TIME={'>10:00<10:55'}>}TIME, -TRX)

[d4rlie891]

Thanks So Much.

May I ask you one more thing, what is the correct Syntax if I want to add AVG on TRX?

the result is null : FirstSortedValue({<TIME={'>10:00<10:55'}>}TIME, -(Avg(TRX))

Thanks

[sunny_talwar]

Find the Avg(TRX) based on what dimension here?

[d4rlie891]

Hi Sunny,

Sorry, here is the detail : I need to know the DAY of Max AVG (ESAP).

For Example, The Max Avg is on Day 9

Thanks

[sunny_talwar]

You want to know the day of max average? may be this:

FirstSortedValue(DAY, -Aggr(Avg(TRX), DAY))

[d4rlie891]

It' Work, Thanks For your Help