Hi,
I have these two queries
This one gets the number of camera sessions
index=wholesale_app buildTarget=blah product=* analyticType=DynamicChoice Properties.index=2 Properties.args{}=CONNECTED |stats count as camerasessions
This one gets the number of camera sessions that had a problem
index=wholesale_app DynamicChoice Properties.index=3 buildTarget=blah product=*|dedup clientSessionId|stats count as camerafailures
What I'd like to do is "combine" the two so I can get the percentage of camera sessions that had a problem from the total. (i.e. divide the result of query 2 by the result of query 1
I've tried several different things but no joy...
Give this a try
index=wholesale_app product=* buildTarget=blah (analyticType=DynamicChoice Properties.index=2 Properties.args{}=CONNECTED ) OR (DynamicChoice Properties.index=3) |stats count as camerasessions dc(clientSessionId) as camerafailures
| eval "CameraFailure%"=round(camerafailures*100/camerasessions,2)
Give this a try
index=wholesale_app product=* buildTarget=blah (analyticType=DynamicChoice Properties.index=2 Properties.args{}=CONNECTED ) OR (DynamicChoice Properties.index=3) |stats count as camerasessions dc(clientSessionId) as camerafailures
| eval "CameraFailure%"=round(camerafailures*100/camerasessions,2)
Hi Somesoni2,
You know I hate you right? 🙂
Many thanks!!!! Works perfectly!