How to customize a drilldown so users can only click on the field name in a table, not the sparkline or percentage?

[dbcase]

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?

[sundareshr · Accepted solution]

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>

[dbcase]

Now that is very slick!!! Worked like a charm!!!! Thanks Sundareshr!!!