Is there a way, besides fillnull, to do an eval if(averageResponse=0, 0.000)? Basically, I want to be able to have the stats table show a result of 0.000 for a field if the results after the stats field is 0 without using a fillnull field in the case where every defined field is equalling zero. This is the base search: | datamodel metric summariesonly=true search | search "metric.date"=2021-06-11 | rename "metric.date" as date | rename "metric.uri_path" as uri_path | eval category=case(like(uri_path, "/as/%/resume/as/authorization.ping"), "highPriority", uri_path="/pf/heartbeat.ping", "unattended", uri_path="/?REF=undefined", "lowPriority", uri_path="/header-logo.svg", "largePayload") | rename "metric.response_time" as response_time | stats avg(response_time) by category | rename avg(response_time) as averageResponse | eval averageResponse=round(averageResponse,3) | transpose 0 header_field=category | fillnull value=0.000 highPriority, lowPriority, largePayload, unattended | eval _time="$date$" | fields highPriority, lowPriority, largePayload, unattended, _time
... View more