I am attempting to eval a new field, from two other fields:     
   
   
 | eval 4XXError=if(metric_name="4XXError", statistic_value, null()) 
| eval 5XXError=if(metric_name="5XXError", statistic_value, null()) 
| eval total_errors='4XXError'+'5XXError' 
   
   
   
 when I come to stat them out: 
   
   
 | stats last(4XXError), last(5XXError), last(total_errors) by api_name, http_method, url 
   
   
   
 the total_errors column is just blank:     
    
   
 where am i going wrong?  
   
 also why does 4XXError need to be single-quoted? is it because it starts with a number? 
   
						
					
					... View more