I currently am building a dashboard and want to take two of my single value pannels results and divide them. I want this result to show in the third pannel. This is what I have:
<form>
<label>Customer Stats. Clone</label>
<fieldset submitButton="false" autoRun="true">
<input type="dropdown" token="account_drop" searchWhenChanged="true">
<label>Account Name</label>
<fieldForLabel>Account Name</fieldForLabel>
<fieldForValue>Account Name</fieldForValue>
<search>
<query>source="LMCustomerRevLicense.csv" | dedup "Account Name" |</query>
<earliest>0</earliest>
<latest></latest>
</search>
</input>
<input type="text" token="field1">
<label>License Key</label>
<default></default>
</input>
</fieldset>
<row>
<panel>
<single>
<title>License Key</title>
<search>
<query>source="LMCustomerRevLicense.csv" $account_drop$ | dedup "Account Name" | table "License Key Identifier"</query>
<earliest>0</earliest>
<latest></latest>
</search>
<option name="drilldown">none</option>
<option name="height">116</option>
<option name="refresh.display">progressbar</option>
</single>
</panel>
</row>
<row>
<panel>
<single>
<title>Total Annual Revenue</title>
<search>
<query>source="LMCustomerRevLicense.csv" $account_drop$ | dedup "Account Name" | table "Total Active Subscription Revenue _converted"</query>
<earliest>0</earliest>
<latest></latest>
</search>
<option name="drilldown">none</option>
<option name="refresh.display">progressbar</option>
</single>
</panel>
<panel>
<single>
<title>Documents Processed</title>
<search>
<query>source="c:\\users\\ragate\\desktop\\splunk\\jsondump.txt" OR source="LMCustomerRevLicense1.csv" $field1$ | eval "LicenseKeyID"=substr('context.custom.dimensions{}.LicenseKey' ,4,7) | eval LicenseKeyID= coalesce(LicenseKeyID, 'License Key Identifier') | table "LicenseKeyID" "Account Name" "context.custom.dimensions{}.DocumentSessionId" | stats distinct_count("context.custom.dimensions{}.DocumentSessionId")</query>
<earliest>0</earliest>
<latest></latest>
</search>
<option name="drilldown">none</option>
<option name="refresh.display">progressbar</option>
</single>
</panel>
</row>
<row>
<panel>
<single>
<title>Documents per $</title>
<search>
<query></query>
<earliest>0</earliest>
<latest></latest>
</search>
<option name="drilldown">none</option>
<option name="refresh.display">progressbar</option>
</single>
</panel>
</row>
<row>
<panel>
<title>Distinct Users</title>
<chart>
<search>
<query>host="ragate-lt1" $field1$ | chart count by context.user.anonId</query>
<earliest>1529280000</earliest>
<latest>1529539200</latest>
<sampleRatio>1</sampleRatio>
</search>
<option name="charting.chart">bar</option>
<option name="refresh.display">progressbar</option>
</chart>
</panel>
<panel>
<title>Distinct Sessions</title>
<chart>
<search>
<query>sourcetype="jsondump" $field1$ | top limit=20 "context.session.id"</query>
<earliest>1529280000</earliest>
<latest>1529539200</latest>
<sampleRatio>1</sampleRatio>
</search>
<option name="charting.chart">bar</option>
<option name="charting.drilldown">none</option>
<option name="refresh.display">progressbar</option>
</chart>
</panel>
</row>
</form>
I would like to divide the Total Annual Revenue by the Documents Processed and have this result show up in the Documents per $.
Anyone know how this could be done.
Thanks in advance.
@Ragate, refer to my previous answer for two approach to solve this issue of having two single value panels and use their values to show result in 3rd Single value
.
https://answers.splunk.com/answers/613939/how-to-calculate-percentage-based-on-2-different-s.html
Please adjust to your need and confirm. If you need further assistance, kindly let us know!