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!

Introducing the 2024 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...

Introducing the 2024 Splunk MVPs!

We are excited to announce the 2024 cohort of the Splunk MVP program. Splunk MVPs are passionate members of ...

Splunk Custom Visualizations App End of Life

The Splunk Custom Visualizations apps End of Life for SimpleXML will reach end of support on Dec 21, 2024, ...