Hello,
This is my query
| loadjob savedsearch="myquery"
| where strftime(_time, "%Y-%m-%d") >= "2020-02-26"
| stats dc(eval(if((STEP=="show"),ID_RF_ATOS,NULL))) AS show,
dc(eval(if((STEP=="clic"),ID_RF_ATOS,NULL))) AS clic,
dc(eval(if((STEP=="send"),ID_RF_ATOS,NULL))) AS send by company,city
| where show>0
| stats sum(show) AS show,sum(clic) AS clic,sum(send) AS send by city
| eval rate= round(((show - (clic+send))/show*100),2)." %"
| table city,show,clic,send,rate
I want to calculate the rate by city and add it to the table
you already calculate. what's wrong?
i don't know what was the problem but now it's works 🙂
I close your question. OK?
yes please