Drilldown Sparkline

[fb12345]

Hey,

I have an Dashboard similiar to the attached one, also with an Sparkline. Now I want a drilldown to another Dashboard and I want to pass the Location to the other Dashboard.

Example: 

1. Click on single Value of New York

2. Drilldown to the other Dashboard 

3. Dropdown in the other Dashboard, where New York is selected

Does anybody know how this is possible?

Thanks in advance

<dashboard>

  <label>testme</label>

  <row>

    <panel>

      <single>

        <search>

          <query>

<![CDATA[            

| makeresults

| eval Location="New York", value=1

| append

    [| makeresults

    | eval Location="Berlin", value=2 ]

| timechart avg(value) by Location

| search Berlin=*        

]]>  

          </query>

        </search>

        <option name="colorBy">value</option>

        <option name="colorMode">block</option>

        <option name="drilldown">all</option>

        <option name="height">150</option>

        <option name="numberPrecision">0.0</option>

        <option name="rangeColors">["0x555","0x53a051","0xf8be34","0xdc4e41"]</option>

        <option name="rangeValues">[$service_003.threshold_normal$,$service_003.threshold_medium$,$service_003.threshold_critical$]</option>

        <option name="refresh.display">progressbar</option>

        <option name="showSparkline">$measurements.showSparkline$</option>

        <option name="showTrendIndicator">$measurements.showTrendIndicator$</option>

        <option name="trellis.enabled">1</option>

        <option name="trellis.scales.shared">1</option>

        <option name="trellis.size">small</option>

        <option name="trendColorInterpretation">standard</option>

        <option name="trendDisplayMode">absolute</option>

        <option name="trendInterval">auto</option>

        <option name="unitPosition">after</option>

        <option name="useColors">1</option>

        <option name="useThousandSeparators">1</option>

        <drilldown>

          <link target="_blank">/app/hsy_ops_da_servicetrace/hsy_kpi_dynamic_2?form.service=$service_003.name$</link>

        </drilldown>

      </single>

    </panel>

  </row>

</dashboard>

[fb12345]

Hey,

thank you for your answer and it also works partially, but the token click.name2 has always the value "result" ,  no matter whether  I click on the Single value of "berlin" or on the single value of "New York". Therefore, the condition would always be true, when the single values of Berlin and New York are the same and this could happen in my dashboard.

Do you have any other idea, how to solve it?

[Vardhan]

Hi,

Try the below one it will work.  Mention the filed name in the place of result.And field value in the condition. And we are passing the field value  "Newyork"  explicitly to the token.

<drilldown>
<condition match="'click.name2' == &quot;result&quot; AND 'click.value2' == &quot;Newyork&quot;">
<set token="testing">$row.Newyork$</set>
<link target="_blank">(Dashboardlink)?result="$testing$"</link>
</condition>

[Vardhan · Accepted solution]

Hi,

Try the below settings its not a accurate one .Feel free to modify if it is necessary.

<drilldown>
<condition match="'click.name2' == &quot;(Mention your row name)&quot; AND 'click.value2' == &quot;(Mention your row value)&quot;">
<set token="test">$row.Newyork$</set>
<link target="_blank">other dashboard link</link>
</condition>
</drilldown>