5K members online now
5K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply
Highlighted

Get Corresponding Time of Max(Field)

Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

I have a list of battery voltage readings (every 10 minutes):

Date_Time, voltage

I want to display a table showing:

Date, Max(voltage), time of Max(voltage), Min(voltage), time of Min(voltage)

 

I can get the Date, Max(voltage) and Min(voltage), but how can I get the "time of Max(voltage)" or "Time of Min(voltage)"?