I've tried this and then it still says N/A on my dashboard.
Current string:
index=project_omega host=PersistUBS | transaction startswith="Targeting file BP_Comp_Summ_Pos*" endswith="Server returned an error: No such file or folder" OR "The file was downloaded successfully." | search "Error" OR "Attempt 3...unsuccessful."
| eval interval=relative_time(_time,"@d")
| eval isFailure=if(searchmatch("Error") OR searchmatch("Attempt 3...unsuccessful."),1,0)
| stats sum(isFailure) as failures
| eval failuresCategory = case(failures=0,"low",failures<3,"elevated",failures>=3,"severe")
| eval range = case(failures=0,"low",failures<3,"elevated",failures>=3,"severe")
... View more