8 Replies Latest reply: Aug 14, 2016 10:18 PM by Darmawan Suria

# How to Get Date and Time from Max Transaction

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

• ###### Re: How to Get Date and Time from Max Transaction

FirstSortedValue(DAY, -TRX)

FirstSortedValue(TIME, -TRX)

• ###### Re: How to Get Date and Time from Max Transaction

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

• ###### Re: How to Get Date and Time from Max Transaction

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

• ###### Re: How to Get Date and Time from Max Transaction

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

• ###### Re: How to Get Date and Time from Max Transaction

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

• ###### Re: How to Get Date and Time from Max Transaction

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

• ###### Re: How to Get Date and Time from Max Transaction

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

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

• ###### Re: How to Get Date and Time from Max Transaction

It' Work, Thanks For your Help