Dashboards & Visualizations

Drilldown Sparkline

fb12345
Engager
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>
Labels (1)
0 Karma
1 Solution

Vardhan
Contributor

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>

View solution in original post

0 Karma

fb12345
Engager

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?

 

0 Karma

Vardhan
Contributor

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>

0 Karma

Vardhan
Contributor

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>

View solution in original post

0 Karma
.conf21 Now Fully Virtual!
Register for FREE Today!

We've made .conf21 totally virtual and totally FREE! Our completely online experience will run from 10/19 through 10/20 with some additional events, too!