Hi, I would like to create a chart of the error rate over time. I have data that shows status= DOWNLOAD_COMPLETE and status = FAILD
I can calculate this for a point in time with the below. But can anyone help get the error rate over time?
logType=error OR logType=service context=retrieve status=DOWNLOAD_COMPLETE OR status=FAILED
| stats count(correlationId) as total_count by status | transpose header_field=status
| eval errorRate=FAILED/(FAILED+DOWNLOAD_COMPLETE)*100
| table DOWNLOAD_COMPLETE, FAILED, errorRate
This should do it.
logType=error OR logType=service context=retrieve status=DOWNLOAD_COMPLETE OR status=FAILED
| timechart count(correlationId) as total_count by status
| eval errorRate=FAILED/(FAILED+DOWNLOAD_COMPLETE)*100
This should do it.
logType=error OR logType=service context=retrieve status=DOWNLOAD_COMPLETE OR status=FAILED
| timechart count(correlationId) as total_count by status
| eval errorRate=FAILED/(FAILED+DOWNLOAD_COMPLETE)*100