Splunk Search

How to divide a sum based values/count ?

aryamehr360
New Member
| stats sum("Sum of consumption") as Total_Consumption count as Session

I got as a result in splunk / statistics chart:

  • Total_Consumption 750.580
  • Session 25

Now I want to divide them to get the average of consumption per session,
to show it on my dashboard.

Labels (1)
0 Karma
1 Solution

to4kawa
Ultra Champion
....
|eval divide=Total_Consumption / Session

Now I want to divide them to get the avrage of consumption per session,

Sorry, I don't understand that divide them = get the avrage of consumption per session,
Only divide, this query is. but I think per session is another way.

View solution in original post

0 Karma

to4kawa
Ultra Champion
....
|eval divide=Total_Consumption / Session

Now I want to divide them to get the avrage of consumption per session,

Sorry, I don't understand that divide them = get the avrage of consumption per session,
Only divide, this query is. but I think per session is another way.

0 Karma
Get Updates on the Splunk Community!

Aligning Observability Costs with Business Value: Practical Strategies

 Join us for an engaging Tech Talk on Aligning Observability Costs with Business Value: Practical ...

Mastering Data Pipelines: Unlocking Value with Splunk

 In today's AI-driven world, organizations must balance the challenges of managing the explosion of data with ...

Splunk Up Your Game: Why It's Time to Embrace Python 3.9+ and OpenSSL 3.0

Did you know that for Splunk Enterprise 9.4, Python 3.9 is the default interpreter? This shift is not just a ...