topic Re: Error in 'where' command becuase of ',' in Dashboards & Visualizations

Error in 'where' command becuase of ','

Questioner — Wed, 06 Dec 2023 10:23:45 GMT

When I use my code, I can see this error.

" Error in 'where' command : The operator at ',127.542 - 0.001' is invalid.

The problem code is this.

| where time >= $max_value$ - 0.001

When I print "max_value" at title, I can see that value is "315,127.542"

I think the reason this problem occurred is ',' at the max_value.

How could I remove ',' at the max_value?

And If it was not the problem, How could I solve this?

Re: Error in 'where' command becuase of ','

PickleRick — Wed, 06 Dec 2023 11:09:46 GMT

OK. The question is where are you getting this token from. Because apparently it's a formatted number which indeed might cause the error.

Re: Error in 'where' command becuase of ','

bowesmana — Wed, 06 Dec 2023 22:16:03 GMT

Technically you could do the following to fix the symptoms

| where time >= tonmumber(replace($max_value$, ",", "")) - 0.001

but you are better off finding the source of the token, as @PickleRick says, and make sure it contains something suitable to perform calculations with if that's how you intend to use it.

Re: Error in 'where' command becuase of ','

Questioner — Thu, 07 Dec 2023 02:19:24 GMT

OH..! I get this token at <single> block.

The code for this <signle> block looks like this.

<single>
<title>Max time</title>
  <search>
   <query>index=idx_prd_analysis sourcetype="type:prd_analysis:delay_time" corp="delay"
    | where (plane_type==1) OR (plane_type==2)
    | eval total_time = round(takeOff_time - boarding_time, 3)
    | stats MAX(total_time)</query>
   <earliest>$_time.earliest$</earliest>
   <latest>$_time.latest$</latest>
  </search>
 <option name="colorMode">block</option>
 <option name="drilldown">all</option>
 <option name="height">154</option>
 <option name="numberPrecision">0.000</option>
 <option name="rangeValues">[500]</option>
 <option name="refresh.display">progressbar</option>
 <option name="unitPosition">before</option>
 <drilldown>
  <set token="max_value">$click.value$</set>
 </drilldown>
</single>

Are there any solution to send max_value as normal format not origin? (Not 123,456 -> Wnat 123456)

Re: Error in 'where' command becuase of ','

bowesmana — Thu, 07 Dec 2023 23:05:47 GMT

You can use an <eval> statement for your drilldown instead of <set>

<eval token="max_value">replace($click.value$, ",", "")</eval>

Re: Error in 'where' command becuase of ','

Questioner — Fri, 08 Dec 2023 04:24:15 GMT

It work!!!
Thank you for your help