The following query shows the average usage of our Puma web server.
SELECT ( abs(1) - filter(average(newrelic.timeslice.value OR 0), where metricTimesliceName = 'Custom/Puma/pool_capacity') / filter(average(newrelic.timeslice.value OR 0), where metricTimesliceName = 'Custom/Puma/max_threads') ) * 100.0 AS '% Usage' from Metric where appName = 'App Server' TIMESERIES
Here the formula is (1 - pool_capacity / max_spawned_threads) * 100.0
I want to show the numbers which are generated from this query as percentage on the dashboard.
How can I do that?