Splunk Search

where clause with a variable

Contributor

Hi.

I need to get sum of totalrevenue where churn=1.
I am able to get the count of churn whose churn=1 and total count of chur but not for other variable total
revenue.
Can any one help me out to achieve this

I used the query to get count churn=1 :
sourcetype="CustomerChurn"

| eval CHURN = if(CHURN="1",1,0)
| stats sum(CHURN) as Churned
Customers,count(CHURN) as Total_Churn by PLACEMENT

Thanks,
Santhosh.

0 Karma
1 Solution

Builder
0 Karma

Builder
0 Karma

Contributor

Thank you @vganjare
sourcetype="CustomerChurn"

| eventstats sum(Total
Revenue) as ff by PLACEMENT
| where CHURN="1"
| stats sum(Total_Revenue) by PLACEMENT

0 Karma

Contributor

@vganjare, Can we able to get sum(total_revenue) without any condition. in the same query.

0 Karma

Builder

using eventstats, all the events are updated with new fields i.e. if you use eventstats sum(Total_Revenue) , then all the events will have same value for sum field. More @ http://docs.splunk.com/Documentation/Splunk/6.2.2/SearchReference/Eventstats

Builder

Hi,

Not able to understand the question. Can you please elaborate?

Thanks,
Vishal

0 Karma

Contributor

I need the sum(totalrevenue) where churn=1.
I have two variable total revenue and churn. churn has two values 1 and 0.
like in SQL: select sum(total
variable) from mysourcetable where churn=1

0 Karma