https://community.splunk.com/t5/Splunk-Search/How-do-you-calculate-the-difference-between-two-specific-values/m-p/422690#M121375 <P>Is it like this?</P> <PRE><CODE> index=example event="Entered Site" OR event="Checkout" | timechart span=1h count(eval(event="Entered Site")) as Entered,count(eval(event="Checkout")) as Checkout | eval percent=round(Checkout/Entered,2) | table _time,percent </CODE></PRE> Thu, 11 Oct 2018 00:47:48 GMT HiroshiSatoh 2018-10-11T00:47:48Z https://community.splunk.com/t5/Splunk-Search/How-do-you-calculate-the-difference-between-two-specific-values/m-p/422689#M121374 <P>How do you calculate the difference between two specific values in the same field and return that value in a percent format? I then need to be able to timechart that percentage difference over time, for my example this would be </P> <P>conversion rate % span 1h </P> <P>I've seen a few eval calculation example but none that gave me the output I'm looking for </P> <PRE><CODE>index=example event="Entered Site" OR event="Checkout" | top event | eval percent = round(percent, 2) </CODE></PRE> Wed, 10 Oct 2018 23:37:36 GMT https://community.splunk.com/t5/Splunk-Search/How-do-you-calculate-the-difference-between-two-specific-values/m-p/422689#M121374 johnward4 2018-10-10T23:37:36Z https://community.splunk.com/t5/Splunk-Search/How-do-you-calculate-the-difference-between-two-specific-values/m-p/422690#M121375 <P>Is it like this?</P> <PRE><CODE> index=example event="Entered Site" OR event="Checkout" | timechart span=1h count(eval(event="Entered Site")) as Entered,count(eval(event="Checkout")) as Checkout | eval percent=round(Checkout/Entered,2) | table _time,percent </CODE></PRE> Thu, 11 Oct 2018 00:47:48 GMT https://community.splunk.com/t5/Splunk-Search/How-do-you-calculate-the-difference-between-two-specific-values/m-p/422690#M121375 HiroshiSatoh 2018-10-11T00:47:48Z https://community.splunk.com/t5/Splunk-Search/How-do-you-calculate-the-difference-between-two-specific-values/m-p/422691#M121376 <P><span class="lia-inline-image-display-wrapper" image-alt="alt text"><img src="https://community.splunk.com/t5/image/serverpage/image-id/5911iE59A8EB65BA7480C/image-size/large?v=v2&amp;px=999" role="button" title="alt text" alt="alt text" /></span></P> <P>@HiroshiSatoh I'm trying to essentially reproduce the graph below that I have in an application called Mixpanel. I've onboarded the data to Splunk and the field I'm looking to visualization is called "event". In the event there are values called "App Opened" and "Product Checkout Began". I would like to know how you can calculate the % of Product Checkout Began from the total of App Opened and then timechart that % over time. For Example what is my conversion rate % per hour.</P> Thu, 11 Oct 2018 01:08:35 GMT https://community.splunk.com/t5/Splunk-Search/How-do-you-calculate-the-difference-between-two-specific-values/m-p/422691#M121376 johnward4 2018-10-11T01:08:35Z https://community.splunk.com/t5/Splunk-Search/How-do-you-calculate-the-difference-between-two-specific-values/m-p/422692#M121377 <P>The answer was corrected.</P> Thu, 11 Oct 2018 01:30:08 GMT https://community.splunk.com/t5/Splunk-Search/How-do-you-calculate-the-difference-between-two-specific-values/m-p/422692#M121377 HiroshiSatoh 2018-10-11T01:30:08Z