Hi Sumologic Community,
I'm working on a dashboard and when logs are missing for my aggregate query I'd like to display a null value or 0, how can I achieve this with the logs query?
I've tried multiple queries with no luck.
Id'd like something like
_collector=test AND _sourcecategory_test AND service_name="something"
max(response_time) | if (isNull(response_time), "Null",response_time) as latency
So what I need is to display the maximum response time if there are logs else return a Null or 0 value.This issue is that there are missing logs on the timeframe and I don't have any fields.
Can someone suggest how to resolve this?
Please sign in to leave a comment.