Dashboards & Visualizations

Dashboard Panel - Table (Hide Results)


I have a requirement to hide the number of values displayed for each row in a table.

For example- If I have 50 values for an IP address then I want to show only 2 values, and rest should be hidden with a link “show hidden values”.


Labels (2)
0 Karma



This dashboard example shows you how to limit the displayed results to 2, but to retain the full list, which is then used as a token via the drilldown to a new panel with the full list.

  <label>test mv</label>
          <query>| makeresults
| eval n=mvrange(1,1801)
| mvexpand n
| eval Id=random() % 20 + 1, Value=random()
| stats values(Value) as Values by Id
| eval LimitedValues=mvindex(Values,0,1)
| sort Id</query>
        <option name="count">100</option>
        <option name="dataOverlayMode">none</option>
        <option name="drilldown">row</option>
        <option name="percentagesRow">false</option>
        <option name="refresh.display">progressbar</option>
        <option name="rowNumbers">false</option>
        <option name="totalsRow">false</option>
        <option name="wrap">true</option>
          <set token="id">$row.Id$</set>
          <set token="values">$row.Values$</set>
    <panel depends="$id$">
          <query>| makeresults
        | eval Id=$id$
        | eval Values=split($values|s$,",")
        | eval Count=mvcount(Values)
        | table Id, Count, Values
        | sort Values</query>
        <option name="refresh.display">progressbar</option>
          <unset token="id"></unset>

Hope this gives you some direction.


0 Karma
Get Updates on the Splunk Community!

Splunk Lantern | Getting Started with Edge Processor, Machine Learning Toolkit ...

Splunk Lantern is Splunk’s customer success center that provides advice from Splunk experts on valuable data ...

Enterprise Security Content Update (ESCU) | New Releases

In the last month, the Splunk Threat Research Team (STRT) has had 2 releases of new security content via the ...

Announcing the 1st Round Champion’s Tribute Winners of the Great Resilience Quest

We are happy to announce the 20 lucky questers who are selected to be the first round of Champion's Tribute ...