hi,
I created a static table then I am retrieving minutes from the table to a drop-down-list,
then I am trying to use the values from the dro-list to present another static table based on the drop-down selection.
The static table code see in the screenshot.
Please advise, I am trying to resolve this issue several days.
I based it on this tutorial but the base search was not working for me https://www.youtube.com/watch?v=cdWXKBzPZ78
this is my main search --> version error* | table date_year,date_month,date_mday,date_hour,date_minute,date_second ,version,host,error,source | rename date_year as year , date_month as month ,date_mday as day ,date_hour as hour,date_minute as minute ,date_second as second| sort year ,day,hour,minute,second |fillnull value="not defined" year,version,error
<form>![alt text][1]
<label>Dashboard test</label>
<fieldset submitButton="true">
<input type="dropdown" token="minute" searchWhenChanged="false">
<label>Minutes</label>
<search>
<query>version error* | table date_year,date_month,date_mday,date_hour,date_minute,date_second ,version,host,error,source | rename date_year as year , date_month as month ,date_mday as day ,date_hour as hour,date_minute as minute ,date_second as second| sort year ,day,hour,minute,second |fillnull value="not defined" year,version,error | stats count by minute</query>
<earliest>-24h@h</earliest>
<latest>now</latest>
</search>
<fieldForLabel>minute</fieldForLabel>
<fieldForValue>minute</fieldForValue>
<choice value="*">All</choice>
<default>*</default>
<initialValue>*</initialValue>
</input>
<input type="dropdown" searchWhenChanged="false" token="hour">
<label>Hours</label>
<choice value="*">All</choice>
<search>
<query>version error* | table date_year,date_month,date_mday,date_hour,date_minute,date_second ,version,host,error,source | rename date_year as year , date_month as month ,date_mday as day ,date_hour as hour,date_minute as minute ,date_second as second| sort day,hour,minute,second |fillnull value="not defined" year,version,error | stats count by hour</query>
<earliest>-24h@h</earliest>
<latest>now</latest>
</search>
<fieldForLabel>hour</fieldForLabel>
<fieldForValue>hour</fieldForValue>
<default>*</default>
<initialValue>*</initialValue>
</input>
</fieldset>
<row>
<panel>
<single>
<title>Error count</title>
<search>
<query>version error* minute=$minute$ hour=$hour$ | table date_year,date_month,date_mday,date_minute,date_second ,version,host,error,source | mvexpand error| rename date_year as year , date_month as month ,date_mday as day ,date_hour as hour,date_minute as minute ,date_second as second| sort day,minute,second |fillnull value=\"not_defined\" year,version,error | stats count by error</query>
<earliest>-24h@h</earliest>
<latest>now</latest>
</search>
<option name="drilldown">none</option>
<option name="colorBy">value</option>
<option name="colorMode">none</option>
<option name="numberPrecision">0</option>
<option name="showSparkline">1</option>
<option name="showTrendIndicator">1</option>
<option name="trendColorInterpretation">standard</option>
<option name="trendDisplayMode">absolute</option>
<option name="useColors">0</option>
<option name="useThousandSeparators">1</option>
<option name="linkView">search</option>
</single>
</panel>
<panel>
<table>
<title>Result table</title>
<search>
<query>version error* minute=$minute$ AND hour=$hour$ | table date_year,date_month,date_mday,date_hour,date_minute,date_second ,version,host,error,source | rename date_year as year , date_month as month ,date_mday as day ,date_hour as hour,date_minute as minute ,date_second as second| sort year ,day,hour,minute,second |fillnull value="not defined" year,version,error</query>
<earliest>-30d@d</earliest>
<latest>now</latest>
</search>
<option name="wrap">true</option>
<option name="rowNumbers">false</option>
<option name="drilldown">cell</option>
<option name="dataOverlayMode">none</option>
<option name="count">10</option>
</table>
</panel>
</row>
<row>
<panel>
<title>Table</title>
<table>
<title>Error table</title>
<search>
<query>version error* | table date_year,date_month,date_mday,date_hour,date_minute,date_second ,version,host,error,source | rename date_year as year , date_month as month ,date_mday as day ,date_hour as hour,date_minute as minute ,date_second as second| sort year ,day,hour,minute,second |fillnull value="not defined" year,version,error</query>
<earliest>-24h@h</earliest>
<latest>now</latest>
</search>
<option name="wrap">undefined</option>
<option name="rowNumbers">undefined</option>
<option name="drilldown">row</option>
<option name="dataOverlayMode">none</option>
<option name="count">50</option>
</table>
</panel>
</row>
</form>
... View more