Data Studio
2K members online now
2K members online now
Ask questions about Data Studio
Guide Me

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)"?