https://community.splunk.com/t5/Splunk-Search/Stats-extract/m-p/195521#M56371 <P>Try</P> <PRE><CODE>| stats avg(Value1) avg(Value2) by Value3 </CODE></PRE> <P>or whatever you like!</P> Wed, 19 Mar 2014 23:04:31 GMT lguinn2 2014-03-19T23:04:31Z https://community.splunk.com/t5/Splunk-Search/Stats-extract/m-p/195520#M56370 <P>I have 3 values extracted from a search Value 1 ,2, and 3</P> <P>I know i can use stats avg(Value1) by Value3 to get a nice table but how can i throw in Value2 also in a mix.</P> <P>I wand table with Value 1, Value 2 by Value 3<BR /> eg :<BR /> Uptime, downtime by Hostname</P> Wed, 19 Mar 2014 22:31:23 GMT https://community.splunk.com/t5/Splunk-Search/Stats-extract/m-p/195520#M56370 nikhilmehra79 2014-03-19T22:31:23Z https://community.splunk.com/t5/Splunk-Search/Stats-extract/m-p/195521#M56371 <P>Try</P> <PRE><CODE>| stats avg(Value1) avg(Value2) by Value3 </CODE></PRE> <P>or whatever you like!</P> Wed, 19 Mar 2014 23:04:31 GMT https://community.splunk.com/t5/Splunk-Search/Stats-extract/m-p/195521#M56371 lguinn2 2014-03-19T23:04:31Z