0

Is there a way to get a line chart where I can display the 90th percentile response time from presto hour-wise? The only available metric that is somewhat close to 90th percentile is average and it's not very wise to use that in analytics.

TylerH
  • 20,799
  • 66
  • 75
  • 101
ShreyaKse
  • 45
  • 6

1 Answers1

1

Assuming this is Trino (formerly PrestoSQL), you can use the approx_percentile(value, 0.90) function along with group by on date_trunc('hour', dateTimeCol).

Dain Sundstrom
  • 2,699
  • 15
  • 14