Dashboards & Visualizations

Division in Dashboard using stats count?

SimonSchoppel
Explorer

Hello,

in my dashboard, I use the "stats count" function to show the number of results for a particular search.
Now I want to divide this number by 3 and display the result instead. How to do this?

 

Thank you for your Help!

 

Labels (1)
0 Karma
1 Solution

gcusello
SplunkTrust
SplunkTrust

Hi @SimonSchoppel,

you have to use the eval command at the end of your search:

<your_search>
| stats count
| eval count=count/3

Ciao.

Giuseppe

View solution in original post

gcusello
SplunkTrust
SplunkTrust

Hi @SimonSchoppel,

you have to use the eval command at the end of your search:

<your_search>
| stats count
| eval count=count/3

Ciao.

Giuseppe

SimonSchoppel
Explorer

Thank you very much!!

0 Karma
Get Updates on the Splunk Community!

[Puzzles] Solve, Learn, Repeat: Dynamic formatting from XML events

This challenge was first posted on Slack #puzzles channelFor a previous puzzle, I needed a set of fixed-length ...

Enter the Agentic Era with Splunk AI Assistant for SPL 1.4

  &#x1f680; Your data just got a serious AI upgrade — are you ready? Say hello to the Agentic Era with the ...

Stronger Security with Federated Search for S3, GCP SQL & Australian Threat ...

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