CODEWITHSUNDEEP
sqlprestoapache-superset
ShreyaKse
ShreyaKse

Reputation: 45

Superset Computing 90th percentile response time

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.

Upvotes: 0

Views: 1705

Answers (1)

Dain Sundstrom
Dain Sundstrom

Reputation: 2858

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).

Upvotes: 1

Related Questions