Dashboards & Visualizations

How to pass values between panels to make calculations?

majeedk_nbg
Engager

I have 6 panels on my dashboard and each one of then shows number of customers going through each phase of journey. Take this made up example:

Panel 1:       Panel 2:        Panel 3:               Panel 4:        Panel5: 

400                    250              330                  120                      80

 

Is it possible add panel 6, which automatically shows the  difference of values from Panel 1 and Panel 2

The queries behind are very complex so I don't re run the same two queries inside Panel 6 to get this value.

 

    

Labels (2)
Tags (2)
0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust
  <row>
    <panel>
      <table>
        <search>
          <done>
            <set token="tablevalue1">$result.value$</set>
          </done>
          <query>| makeresults
| eval value="ABC"
| table value</query>
          <earliest>-24h@h</earliest>
          <latest>now</latest>
        </search>
        <option name="drilldown">none</option>
        <option name="refresh.display">progressbar</option>
      </table>
    </panel>
    <panel>
      <table>
        <search>
          <done>
            <set token="tablevalue2">$result.value$</set>
          </done>
          <query>| makeresults
| eval value="DEF"
| table value</query>
          <earliest>-24h@h</earliest>
          <latest>now</latest>
        </search>
        <option name="drilldown">none</option>
        <option name="refresh.display">progressbar</option>
      </table>
    </panel>
  </row>
  <row>
    <panel>
      <html>
Value from first table = $tablevalue1$<br/>
Value from second table = $tablevalue2$
      </html>
    </panel>
  </row>

View solution in original post

0 Karma

majeedk_nbg
Engager

@ITWhisperer can you please provide an example?  

0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
  <row>
    <panel>
      <table>
        <search>
          <done>
            <set token="tablevalue1">$result.value$</set>
          </done>
          <query>| makeresults
| eval value="ABC"
| table value</query>
          <earliest>-24h@h</earliest>
          <latest>now</latest>
        </search>
        <option name="drilldown">none</option>
        <option name="refresh.display">progressbar</option>
      </table>
    </panel>
    <panel>
      <table>
        <search>
          <done>
            <set token="tablevalue2">$result.value$</set>
          </done>
          <query>| makeresults
| eval value="DEF"
| table value</query>
          <earliest>-24h@h</earliest>
          <latest>now</latest>
        </search>
        <option name="drilldown">none</option>
        <option name="refresh.display">progressbar</option>
      </table>
    </panel>
  </row>
  <row>
    <panel>
      <html>
Value from first table = $tablevalue1$<br/>
Value from second table = $tablevalue2$
      </html>
    </panel>
  </row>
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

Assuming you are using SimpleXML dashboards, you could try adding a <done></done> block to your dashboard panel searches and store a value from the result into a token, then display those token values in panel 6

0 Karma
Get Updates on the Splunk Community!

Splunk Observability Cloud | Unified Identity - Now Available for Existing Splunk ...

Raise your hand if you’ve already forgotten your username or password when logging into an account. (We can’t ...

Index This | How many sides does a circle have?

February 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

Registration for Splunk University is Now Open!

Are you ready for an adventure in learning?   Brace yourselves because Splunk University is back, and it's ...