https://community.splunk.com/t5/Splunk-Search/How-to-use-timechart-with-a-calculated-field/m-p/246296#M73431 <P>I have this search that displays my conversion rate:</P> <PRE><CODE>tag=external_traffic eventtype=pageactions session_id=\* | transaction session_id startswith=(referrer=/store/category/page) maxpause=30m mvlist=f | eval didco = if(match(url, "/checkout/order"), 1, 0 ) | stats sum(didco) as cr , count as sessions by experienceId | eval conv_rate = cr/sessions | table experienceId conv_rate </CODE></PRE> <P>This gives me the conversion rate for the search period, but how can I do this as a daily number?</P> <P>Notice the "experienceId" there are 2 experiences on the site, and I want to see the conversion rate for both them on a daily chart. </P> Wed, 11 May 2016 18:52:40 GMT ra01 2016-05-11T18:52:40Z https://community.splunk.com/t5/Splunk-Search/How-to-use-timechart-with-a-calculated-field/m-p/246296#M73431 <P>I have this search that displays my conversion rate:</P> <PRE><CODE>tag=external_traffic eventtype=pageactions session_id=\* | transaction session_id startswith=(referrer=/store/category/page) maxpause=30m mvlist=f | eval didco = if(match(url, "/checkout/order"), 1, 0 ) | stats sum(didco) as cr , count as sessions by experienceId | eval conv_rate = cr/sessions | table experienceId conv_rate </CODE></PRE> <P>This gives me the conversion rate for the search period, but how can I do this as a daily number?</P> <P>Notice the "experienceId" there are 2 experiences on the site, and I want to see the conversion rate for both them on a daily chart. </P> Wed, 11 May 2016 18:52:40 GMT https://community.splunk.com/t5/Splunk-Search/How-to-use-timechart-with-a-calculated-field/m-p/246296#M73431 ra01 2016-05-11T18:52:40Z https://community.splunk.com/t5/Splunk-Search/How-to-use-timechart-with-a-calculated-field/m-p/246297#M73432 <P>Try this</P> <PRE><CODE>.... | bin span=1d _time | chart sum(didco) as cr , count as sessions over _time by experienceId | ... </CODE></PRE> Wed, 11 May 2016 19:04:30 GMT https://community.splunk.com/t5/Splunk-Search/How-to-use-timechart-with-a-calculated-field/m-p/246297#M73432 sundareshr 2016-05-11T19:04:30Z https://community.splunk.com/t5/Splunk-Search/How-to-use-timechart-with-a-calculated-field/m-p/246298#M73433 <P>that seems like most of the way there if I replace " | stats sum(didco) as cr , count as sessions by experienceId" with what you wrote.</P> <P>The problem is the chart or summary table doesn't show the "conv_rate" field I was trying to calculate. </P> Wed, 11 May 2016 21:05:07 GMT https://community.splunk.com/t5/Splunk-Search/How-to-use-timechart-with-a-calculated-field/m-p/246298#M73433 ra01 2016-05-11T21:05:07Z https://community.splunk.com/t5/Splunk-Search/How-to-use-timechart-with-a-calculated-field/m-p/246299#M73434 <P>You will need to add the <CODE>eval conv_rate=cr/sessions</CODE>. Do you not get the <CODE>conv_rate</CODE> if you add it after the chart command.I used the chart command to give you daily totals. </P> Wed, 11 May 2016 21:15:22 GMT https://community.splunk.com/t5/Splunk-Search/How-to-use-timechart-with-a-calculated-field/m-p/246299#M73434 sundareshr 2016-05-11T21:15:22Z https://community.splunk.com/t5/Splunk-Search/How-to-use-timechart-with-a-calculated-field/m-p/246300#M73435 <P>the conv_rate value doesn't show up on the summary table or the chart. </P> <P>I have it as:<BR /> | bin span=1h _time<BR /> | chart sum(didco) as cr , count as sessions over _time by experienceId<BR /> | eval conv_rate = cr/sessions</P> <P>I am getting summary info for CR and Sessions, just not the conv_rate</P> Tue, 29 Sep 2020 09:41:20 GMT https://community.splunk.com/t5/Splunk-Search/How-to-use-timechart-with-a-calculated-field/m-p/246300#M73435 ra01 2020-09-29T09:41:20Z https://community.splunk.com/t5/Splunk-Search/How-to-use-timechart-with-a-calculated-field/m-p/246301#M73436 <P>What if you add the <CODE>| table experienceId conv_rate</CODE> Does it show then? </P> Wed, 11 May 2016 22:39:09 GMT https://community.splunk.com/t5/Splunk-Search/How-to-use-timechart-with-a-calculated-field/m-p/246301#M73436 sundareshr 2016-05-11T22:39:09Z