https://community.splunk.com/t5/Splunk-Search/How-to-get-data-by-a-field-when-not-using-stats/m-p/127038#M34430 <P>Hi,</P> <P>I am trying to get conversion and average order value and i am using eval function to calculate these. But i want to get these by different applications that we have. If i don't use stats i don't know how to get by application. If i use stats what function to use to just get the evaluated values? i tried values but did not work. </P> <P>| stats dc(OrderNumber) as Orders, dc(sessionid) as Visits | eval CVR =(Orders/Visits)*100 | eval Conversion = round(CVR, 1) | eval AOV=(Revenue/Orders) | eval AOV = round(AOV, 1) | stats values(AOV), values(Conversion) by Application</P> Sun, 03 Nov 2013 16:34:50 GMT xvxt006 2013-11-03T16:34:50Z https://community.splunk.com/t5/Splunk-Search/How-to-get-data-by-a-field-when-not-using-stats/m-p/127038#M34430 <P>Hi,</P> <P>I am trying to get conversion and average order value and i am using eval function to calculate these. But i want to get these by different applications that we have. If i don't use stats i don't know how to get by application. If i use stats what function to use to just get the evaluated values? i tried values but did not work. </P> <P>| stats dc(OrderNumber) as Orders, dc(sessionid) as Visits | eval CVR =(Orders/Visits)*100 | eval Conversion = round(CVR, 1) | eval AOV=(Revenue/Orders) | eval AOV = round(AOV, 1) | stats values(AOV), values(Conversion) by Application</P> Sun, 03 Nov 2013 16:34:50 GMT https://community.splunk.com/t5/Splunk-Search/How-to-get-data-by-a-field-when-not-using-stats/m-p/127038#M34430 xvxt006 2013-11-03T16:34:50Z https://community.splunk.com/t5/Splunk-Search/How-to-get-data-by-a-field-when-not-using-stats/m-p/127039#M34431 <P>Try to use 'eventstats' instead of the first stats.</P> Sun, 03 Nov 2013 17:23:36 GMT https://community.splunk.com/t5/Splunk-Search/How-to-get-data-by-a-field-when-not-using-stats/m-p/127039#M34431 rechteklebe 2013-11-03T17:23:36Z https://community.splunk.com/t5/Splunk-Search/How-to-get-data-by-a-field-when-not-using-stats/m-p/127040#M34432 <P><CODE>| stats dc(OrderNumber) as Orders, dc(sessionid) as Visits by Application | eval CVR =(Orders/Visits)*100 | eval Conversion = round(CVR, 1) | eval AOV=(Revenue/Orders) | eval AOV = round(AOV, 1)</CODE></P> Sun, 03 Nov 2013 20:07:39 GMT https://community.splunk.com/t5/Splunk-Search/How-to-get-data-by-a-field-when-not-using-stats/m-p/127040#M34432 _d_ 2013-11-03T20:07:39Z https://community.splunk.com/t5/Splunk-Search/How-to-get-data-by-a-field-when-not-using-stats/m-p/127041#M34433 <P>Hi Below solution from <EM>d</EM> worked for me. I will try evenstats also and see if it works.</P> Sun, 03 Nov 2013 23:40:35 GMT https://community.splunk.com/t5/Splunk-Search/How-to-get-data-by-a-field-when-not-using-stats/m-p/127041#M34433 xvxt006 2013-11-03T23:40:35Z