I would like to use a drilldown token created from clicking a bar on a timechart and add 1800 to the value and use it in the "latest" tag in the new chart that generates. Here's what I currently have:
<form>
<fieldset submitButton="false" autoRun="true">
<input type="time" token="field1">
<label></label>
<default>
<earliest>-24h@h</earliest>
<latest>now</latest>
</default>
</input>
</fieldset>
<row>
<panel>
<table>
<search>
<query></query>
<earliest>$field1.earliest$</earliest>
<latest>$field1.latest$</latest>
<sampleRatio>1</sampleRatio>
</search>
<option name="drilldown">$click.$value$</option>
<drilldown>
<condition>
<set token="accountNumber">$click.value$</set>
<set token="myAccount">$click.value$</set>
</condition>
</drilldown>
</table>
</panel>
</row>
<row>
<panel depends="$myAccount$">
<title>$myAccount$</title>
<chart>
<search>
<query>accountId=$accountNumber$ | timechart count()</query>
<earliest>$field1.earliest$</earliest>
<latest>$field1.latest$</latest>
</search>
<option name="charting.drilldown">all</option>
<drilldown>
<condition>
<set token="timeSpan">$click.value$</set>
**<eval token="timeSpan2">'click.value$ + 500</eval>**
</condition>
</drilldown>
</chart>
</panel>
<panel depends="$timeSpan$">
<chart>
<search>
<query>accountId=$accountNumber$ | timechart count()</query>
<earliest>$timespan$</earliest>
<latest>**$timeSpan2$**</latest>
</search>
<option name="charting.drilldown">none</option>
</chart>
</panel>
</row>
</form>
I cleared out most of the fluff to make it a bit easier to read through. The $timeSpan$ token works perfectly fine but how do I add 1800 to $timeSpan$ and set that to token $timeSpan2$?
Thank you,
Jonathan
... View more