I have this search that displays my conversion rate:
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
This gives me the conversion rate for the search period, but how can I do this as a daily number?
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.
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.
The problem is the chart or summary table doesn't show the "conv_rate" field I was trying to calculate.
the conv_rate value doesn't show up on the summary table or the chart.
I have it as:
| bin span=1h time
| chart sum(didco) as cr , count as sessions over _time by experienceId
| eval convrate = cr/sessions
I am getting summary info for CR and Sessions, just not the conv_rate