@nishantmishra21
NEXT_PAY_PERIOD_NAME GROUP Total
APRW1-FY18 abc $8,768,545.49
APRW1-FY18 bbc $25,252,666.80
this is my table. if i click on the group column with abc. i have to get chart1 and if i click bbc i need to get chart 2 by unset chart1.
pls correct my code
<panel>
<title>Test</title>
<table>
<search>
<query>|abc.csv| stats sum(AMOUNT) as Total by NAME,GROUP|sort PERIOD|eval Total=round(Total,2)| fieldformat Total= "$" + tostring(Total, "commas")</query>
</search>
<drilldown>
<condition match="$row.colmnname$== value1">
<set token="token1">true</set>
<unset token="token2"></unset>
</condition>
<condition match="$row.colmnname$== value2">
<set token="token2">true</set>
<unset token="token1"></unset>
</condition>
</drilldown>
</table>
</panel>
</row>
<row>
<panel >
<chart depends="$token1$">
<search>
<query>|query|where PAY_GROUP="abc" | stats sum(PAYMENT_AMOUNT) as Total by CODE,PNAME, GROUP|sort- Total|eval Total=round(Total,2)|stats sum by CODE</query>
</search>
<option name="charting.chart">pie</option>
</chart>
</panel>
<panel >
<chart depends="$token2$">
<search>
<query>|query|where PAY_GROUP="abc" | stats sum(PAYMENT_AMOUNT) as Total by CODE,PNAME, GROUP|sort- Total|eval Total=round(Total,2)|stats sum by CODE</query>
</search>
<option name="charting.chart">pie</option>
</chart>
</panel>
</row>
... View more