Hi,
I are trying to generate a search report using the follow query
rangemap field="value"
"<$1"=0-1
"$1-$2"=1-2
"$2-$3"=2-3
"$3-$5"=3-5
|top limit=0 range
If there is no value falls in range 2-3, the report shows as follow
range count percent
<$1 10 50
$1-$2 5 25
$3-$5 5 25
How could I make the report shows as
range count percent
<$1 10 50
$1-$2 5 25
$2-$3 0 0``
$3-$5 5 25
Thanks
... View more