Hi ,
i have produced output below using predict command .
_time Prediction(hostA) Prediction(HostB) Prediction(HostC)
2019-09-18 90 85 70
2019-09-19 95 88 80
2019-09-20 107 95 90
2019-09-21 120 100 93
2019-09-22 121 105 96
2019-09-23 124 106 99
2019-09-24 130 110 100
2019-09-25 131 120 105
But my question is how can i find the earliest _time for each column where that prediction column is 100 or grater that 100.
Expected output :
Host "Hit 100% next 5 Days" 'Earlist date for host hit 100%'
hostA Y 2019-09-20
HostB Y 2019-09-21
HostC N 2019-09-24