Hi,
I have a table with 3 fields in it
MSO (a name field)
Trend (a Sparkline)
Percentage (numeric)
When a user clicks on the MSO field, the drilldown and resulting line chart works great!
But when a user clicks on Trend or Percentage, the drilldown "works" (meaning it creates a panel), but the resulting line chart errors out as the query is trying to search on a trendline or a percentage instead of the MSO field. Is there anyway to limit the user so they can only click on the MSO field? Or..... If they click on any other field in the row, convert the token to the MSO name?
You can do a conditional token. Try this
<drilldown>
<condition field="trend">
<unset token="tablevalue"></unset>
</condition>
<condition field="percent">
<unset token="tablevalue"></unset>
</condition>
<condition field="*">
<set token="tablevalue">$click.value2$</set>
</condition>
</drilldown>
You can do a conditional token. Try this
<drilldown>
<condition field="trend">
<unset token="tablevalue"></unset>
</condition>
<condition field="percent">
<unset token="tablevalue"></unset>
</condition>
<condition field="*">
<set token="tablevalue">$click.value2$</set>
</condition>
</drilldown>
Now that is very slick!!! Worked like a charm!!!! Thanks Sundareshr!!!