Splunk Search

Stats values to be calculated in 2 ways for a dashboard base query

varsh_6_8_6
Explorer

Hi,
I have 2 panels for which the events flow is high and so I am trying to include the stats command along with the fields command in the base query.
I have a field TotalTransaction for which i need stats values as 
"|stats count(TotalTansaction) as tottrans by Tier" for one panel
"|stats count(TotalTransaction) as tottrans by Tier Proxy method" for the other panel

How to get both the stats values included in the same query.

Labels (1)
0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust
|stats count(TotalTransaction) as tottrans by Tier Proxy method
|eventstats sum(tottrans) as totaltrans by Tier

View solution in original post

ITWhisperer
SplunkTrust
SplunkTrust
|stats count(TotalTransaction) as tottrans by Tier Proxy method
|eventstats sum(tottrans) as totaltrans by Tier
Get Updates on the Splunk Community!

Wrapping Up Cybersecurity Awareness Month

October might be wrapping up, but for Splunk Education, cybersecurity awareness never goes out of season. ...

🌟 From Audit Chaos to Clarity: Welcoming Audit Trail v2

🗣 You Spoke, We Listened  Audit Trail v2 wasn’t written in isolation—it was shaped by your voices.  In ...

What's New in Splunk Observability - October 2025

What’s New?    We’re excited to announce the latest enhancements to Splunk Observability Cloud and share ...