Eval groupping

[tahasefiani]

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

[to4kawa]

you already calculate. what's wrong?

[tahasefiani]

i don't know what was the problem but now it's works 🙂

[to4kawa]

I close your question. OK?

[tahasefiani]

yes please