topic Re: where clause with a variable in Splunk Search

where clause with a variable

SanthoshSreshta — Mon, 28 Sep 2020 19:54:50 GMT

Hi.

I need to get sum of total_revenue 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="Customer_Churn"

| eval CHURN = if(CHURN="1",1,0)
| stats sum(CHURN) as Churned_Customers,count(CHURN) as Total_Churn by PLACEMENT
Thanks,
Santhosh.

Re: where clause with a variable

vganjare — Mon, 18 May 2015 10:50:55 GMT

Hi,

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

Thanks,
Vishal

Re: where clause with a variable

SanthoshSreshta — Mon, 28 Sep 2020 19:54:52 GMT

I need the sum(total_revenue) 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 my_source_table where churn=1

Re: where clause with a variable

vganjare — Mon, 18 May 2015 10:59:44 GMT

change stats to eventstats. Splunk has where command @ http://docs.splunk.com/Documentation/Splunk/6.2.2/SearchReference/Where

Re: where clause with a variable

SanthoshSreshta — Mon, 28 Sep 2020 19:54:55 GMT

Thank you @vganjare
sourcetype="Customer_Churn"

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

Re: where clause with a variable

SanthoshSreshta — Mon, 18 May 2015 11:09:45 GMT

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

Re: where clause with a variable

vganjare — Mon, 18 May 2015 11:52:44 GMT

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