Here is my code:
index="main" sourcetype="AS-CDR"
|where Called_Number="9999" OR Calling_Number="2155551060" OR Called_Number="2155551060" OR Calling_Number="12155551060" OR Called_Number="+12155551060" OR Calling_Number="+12155551060"
|eval Call_Duration = strptime(Release_Time, "%Y%m%d%H%M%S.%q") - strptime(Start_Time, "%Y%m%d%H%M%S.%q")
|eval TimeToAnswer= strptime(Answer_Time, "%Y%m%d%H%M%S.%q") - strptime(Start_Time, "%Y%m%d%H%M%S.%q")
|eval NormTermTest=if((Termination_Cause=="016" OR Termination_Cause=="017"),1,0)
|eval CallDurTest=if((Call_Duration>15),1,0)
|eval TimeToAnswerTest=if((TimeToAnswer<30),1,0)
|eval NotRedUnav=if(Redirecting_Reason=="unavailable",0,1)
|eval CallScore=((NormTermTest+NotRedUnav+CallDurTest+TimeToAnswerTest)/4)*100
|head 5
|table _time CallScore
What I need to do is convert the two resulting columns into a scatter plot, showing the call score discretely over time. Each individual phone call in the system gets a score, but since we don't know when a particular user will call it doesn't really make sense to use a line chart or a bin (there is no set interval). The management is fiercely against using things like bins because they mask data in the dashboard. Any help would really be appreciated.
Thus far pretty much any other type of chart works except the scatter. Basically i'm looking to see time be the x axis, and the call score at the given time be along the y axis.
... View more