https://community.splunk.com/t5/Splunk-Search/timechart-with-math-function/m-p/82067#M20829 <P>i am using timechart like this</P> <P>search | timechart span=10m avg(diff)</P> <P>but the diff number is in seconds I would like the answer in minutes like this</P> <P>search | timechart span=10m avg(diff)/60</P> <P>this doesn't work</P> <P>Anyone have a suggestion??</P> Tue, 02 Apr 2013 16:04:18 GMT hartfoml 2013-04-02T16:04:18Z https://community.splunk.com/t5/Splunk-Search/timechart-with-math-function/m-p/82067#M20829 <P>i am using timechart like this</P> <P>search | timechart span=10m avg(diff)</P> <P>but the diff number is in seconds I would like the answer in minutes like this</P> <P>search | timechart span=10m avg(diff)/60</P> <P>this doesn't work</P> <P>Anyone have a suggestion??</P> Tue, 02 Apr 2013 16:04:18 GMT https://community.splunk.com/t5/Splunk-Search/timechart-with-math-function/m-p/82067#M20829 hartfoml 2013-04-02T16:04:18Z https://community.splunk.com/t5/Splunk-Search/timechart-with-math-function/m-p/82068#M20830 <P>Before creating your timechart, use an eval function to format your variable the way you would like. So try something like:</P> <P>search | eval diff_in_min=(diff/60) | timechart span=10m avg(diff_in_min)</P> Mon, 28 Sep 2020 13:39:12 GMT https://community.splunk.com/t5/Splunk-Search/timechart-with-math-function/m-p/82068#M20830 BenjaminWyatt 2020-09-28T13:39:12Z https://community.splunk.com/t5/Splunk-Search/timechart-with-math-function/m-p/82069#M20831 <P>thanks much</P> Tue, 02 Apr 2013 16:31:54 GMT https://community.splunk.com/t5/Splunk-Search/timechart-with-math-function/m-p/82069#M20831 hartfoml 2013-04-02T16:31:54Z https://community.splunk.com/t5/Splunk-Search/timechart-with-math-function/m-p/82070#M20832 <P>A simpler way may be to use eval() (as function): <BR /> <CODE>search | timechart span=10m eval(avg(diff)/60) as diff_in_min</CODE></P> Mon, 31 Aug 2015 15:57:21 GMT https://community.splunk.com/t5/Splunk-Search/timechart-with-math-function/m-p/82070#M20832 oaustegard 2015-08-31T15:57:21Z