How to calculate success rate


#1

Hi,
Given the following measurement named results, I was wondering if anyone could advise how to get the success rate?

time                                 value
1550830530007000000  FAIL
1560830530007000000  SUCCESS
1570830530007000000  SUCCESS
1580830530007000000  FAIL
1590830530007000000  SUCCESS

I can see how to get the total number of SUCCESS

SELECT count(*) where value=‘SUCCESS’

but not really sure how to get the rate result for example:

number of success / total * time_range