Dashboards & Visualizations

How to display average from referenced dashboard widget results?

ChadW
Explorer

I have a dashboard that displays 3 radials. I want to display the average of the numeric result of those three radials also on the dashboard. I can create references to those radials and refer to their results something like ($ds_1:result.avg$ + $ds_3:result.avg$ + $ds_3:result.avg$) / 3 but I don't know how to create SPL to do just that vs looking up logs. For example, I tried 

 

 

| eval avg=($ds_1:result.avg$ + $ds_3:result.avg$ + $ds_3:result.avg$) / 3 | table avg

 

 

this didn't work. For context, each of those referred datasources outputs avg(field) as avg. 

How can I achieve what I'm after?

Labels (2)
0 Karma
1 Solution

ChadW
Explorer

I figured this out using makeresults:

| makeresults format=csv data="val
$ds_1:result.avg$
$ds_3:result.avg$
$ds_3:result.avg$" | stats avg(val)

View solution in original post

0 Karma

ChadW
Explorer

I figured this out using makeresults:

| makeresults format=csv data="val
$ds_1:result.avg$
$ds_3:result.avg$
$ds_3:result.avg$" | stats avg(val)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust

In SimpleXML dashboards, you can declare a done handler - in the done handler for each radial search, you can declare a token for the result you want. You can then use these tokens elsewhere in the dashboard.

0 Karma

ChadW
Explorer

I'm using Dashboard Studio. I can reference the final result (like I mentioned in my original post) but that is intended to feed into a search. I just want to use that final result as part of a mathematical equation -- averaging multiple final results together. Is that possible?

0 Karma
Get Updates on the Splunk Community!

Splunk Observability as Code: From Zero to Dashboard

For the details on what Self-Service Observability and Observability as Code is, we have some awesome content ...

[Puzzles] Solve, Learn, Repeat: Character substitutions with Regular Expressions

This challenge was first posted on Slack #puzzles channelFor BORE at .conf23, we had a puzzle question which ...

Shape the Future of Splunk: Join the Product Research Lab!

Join the Splunk Product Research Lab and connect with us in the Slack channel #product-research-lab to get ...