Can anyone explain why the k1 eval token statement does not work, but k2 and k3, which do the same as k1, but in two steps, does.
<eval token="k1">mvindex($row.key$, mvfind($row.name$, $click.v...
See more...
Can anyone explain why the k1 eval token statement does not work, but k2 and k3, which do the same as k1, but in two steps, does.
<eval token="k1">mvindex($row.key$, mvfind($row.name$, $click.value2$))</eval>
<eval token="k2">mvfind($row.name$, $click.value2$)</eval>
<eval token="k3">mvindex($row.key$, $k2$)</eval>
Requirements are: 2 MV fields in a single row with keys in one field and names in the other. drilldown is cell and click.value2 is the clicked name (key column is hidden).
I'm trying to grab the corresponding key for the clicked name. I finally got k2/k3 combination working, but am puzzled why k1 does not work and don't know how to diagnose.
Here's an example dashboard.
<dashboard>
<label>MV Click</label>
<row>
<panel>
<table>
<search>
<query>| makeresults
| fields - _time
| eval name=split("ABCDEFGHIJKL", "")
| eval key=lower(name)
| table name key</query>
<earliest>@d</earliest>
<latest>now</latest>
<sampleRatio>1</sampleRatio>
</search>
<fields>name</fields>
<option name="count">100</option>
<option name="dataOverlayMode">none</option>
<option name="drilldown">cell</option>
<option name="percentagesRow">false</option>
<option name="rowNumbers">false</option>
<option name="totalsRow">false</option>
<option name="wrap">true</option>
<drilldown>
<eval token="k1">mvindex($row.key$, mvfind($row.name$, $click.value2$))</eval>
<eval token="k2">mvfind($row.name$, $click.value2$)</eval>
<eval token="k3">mvindex($row.key$, $k2$)</eval>
<set token="name">$click.value2$</set>
<set token="names">$row.name$</set>
<set token="keys">$row.key$</set>
</drilldown>
</table>
</panel>
<panel>
<html>
<h2>Clicked name=$name$</h2><p/>
<h2>Names=$names$</h2>
<h2>Keys=$keys$</h2><p/>
<h3><eval token="k1">mvindex($row.key$, mvfind($row.name$, $click.value2$))</eval> = $k1$</h3>
<h3><eval token="k2">mvfind($row.name$, $click.value2$)</eval> = $k2$</h3>
<h3><eval token="k3">mvindex($row.key$, $$k2$$)</eval> = $k3$</h3>
</html>
</panel>
</row>
</dashboard>