Re: Clickable word cloud drilldown - must show det...

dojiepreji · ‎02-12-2019

Hello, I have a word cloud in my dashboard.

In my options for the word cloud, I have enabled tokenfields so that when a user clicks on a word, it will pass the value to the token.

 <option name="aiam-common-visual-6_4.wordcloud.tokenfields">[{
          "tokenname":"words",
          "tokenvalue":"click.name"
          }]</option>

I can display the token in the html using this code:

<panel>
      <html>
         <div>
           word: $words$
         </div>
       </html>
    </panel>

I have another table in the same dashboard that aims to display details in which this particular word is found.

<search>
          <query>index="aiam_itsm_ticket_beamsuntory" 
| search problem_abstract="*$words$*"
| table ticket, problem, status, group</query>
          <earliest>-1mon@mon</earliest>
          <latest>@mon</latest>
          <sampleRatio>1</sampleRatio>
        </search>

The problem is that the panel keeps displaying "Search is waiting for input..."

I want it to display the details for the selected word and refresh every time the user clicks on another word.

Any help would be appreciated. Thank you!

renjith_nair · ‎02-13-2019

@dojiepreji ,

Until the token set , the search will not run and that's the reason for "Search is waiting for input.."

Either you can set the default value to the token on the page load , so that some default data is shown until the user 'clicks' on a word
Or
You can hide the panel using depends until the token is set i.e. user clicks on a word

With init

<dashboard>
  <init>
    <set token="sourcetype">"whatever the default value we want to set"</set>
  </init>
  <label>Token based Dashboard</label>
  <row>
    <panel>
      <table>
        <search>
          <query>index=_internal|stats count by sourcetype</query>
          <earliest>-5m</earliest>
          <latest>now</latest>
        </search>
        <option name="drilldown">cell</option>
        <option name="refresh.display">progressbar</option>
        <drilldown>
          <set token="sourcetype">$click.value$</set>
        </drilldown>
      </table>
    </panel>
  </row>
  <row>
    <panel>
      <table>
        <search>
          <query>index=_internal sourcetype="$sourcetype$"|head 10</query>
          <earliest>-5m@m</earliest>
          <latest>now</latest>
        </search>
      </table>
    </panel>
  </row>
</dashboard>

With depends

<dashboard>
  <label>Token based Dashboard</label>
  <row>
    <panel>
      <html>
        <h3><i>Click on a word to show the results</i></h3>
      </html>
    </panel>
  </row>
  <row>
    <panel>
      <table>
        <search>
          <query>index=_internal|stats count by sourcetype</query>
          <earliest>-5m</earliest>
          <latest>now</latest>
        </search>
        <option name="drilldown">cell</option>
        <option name="refresh.display">progressbar</option>
        <drilldown>
          <set token="sourcetype">$click.value$</set>
        </drilldown>
      </table>
    </panel>
  </row>
  <row>
    <panel depends="$sourcetype$">
      <table>
        <search>
          <query>index=_internal sourcetype="$sourcetype$"|head 10</query>
          <earliest>-5m@m</earliest>
          <latest>now</latest>
        </search>
      </table>
    </panel>
  </row>
</dashboard>

---
What goes around comes around. If it helps, hit it with Karma 🙂

dojiepreji · ‎02-13-2019

Drilldown options doesn't work for this specific custom visualization, unfortunately.

renjith_nair · ‎02-13-2019

I think in your case, drill down can be replaced by click. So except the drilldown part ,init or depends should work for you if you are using simple xml

---
What goes around comes around. If it helps, hit it with Karma 🙂

dojiepreji · ‎02-13-2019

Can you please elaborate on how you can perform the click without drilldown?

Clickable word cloud drilldown - must show details in another table in the same dashboard page

Join Us for Splunk University and Get Your Bootcamp Game On!

.conf24 | Learning Tracks for Security, Observability, Platform, and Developers!

Announcing Scheduled Export GA for Dashboard Studio