If i have n numbers of router in my index and i want to know the current status of router if its connected or failed , if its is failed i need to show the router number of the failed router how to display the router number instead of router count , what query i should write
| stats latest(status) as status by router
| where status="failed"
Can you give some sample data (please use </> when you post it)?