SplunkでOPPAI

18133 ワード
Splunk Splunk テキストリンク

https://qiita.com/samuragouchi-monzaemon/items/aa0f42301733c8bd68aa
を見て作りたくなった

oppai.spl
| makeresults count=2 
| streamstats count as x 
| eval x=if(x=1,0.00000,1.80000) 
| makecontinuous x span=0.001 
| eval tmp=mvrange(0,2) 
| mvexpand tmp 
| fields - _time tmp 
| streamstats count by x 
| eval x=if(count=2,-1 * x,x) 
| eval x_1=(1.5*exp(-0.62*pow(x-0.16,2)))/(1+exp(-20*(5*x-1))) 
| eval x_2 = (1.5+0.8*pow(x-0.2,3))*pow(1+exp(20*(5*x-1)),-1) 
| eval x_3 = (1+exp(-(100*(x+1)-16))) 
| eval x_4 = (0.2*(exp(pow(-(x+1),2))+1))/(1+exp(100*(x+1)-16)) 
| eval x_5 = (0.1/exp(pow(2*(10*x-1.2),4))) 
| eval y = round(x_1+(x_2/x_3)+x_4+x_5,4)
| sort 0 x
| table x y

小島 功さん風
どうしても縦にできなかった・・・・

cannot_duplecate_y_axis.spl
| makeresults count=2 
| streamstats count as x 
| eval x=if(x=1,0.000,1.800) 
| makecontinuous x span=0.001 
| eval tmp=mvrange(0,2) 
| mvexpand tmp 
| fields - _time tmp 
| streamstats count by x 
| eval y=if(count=2,-1 * x,x)
| eval x=0.000
| sort 0 y
| table x y

調べてみると、Line ChartはY軸で重ねられないらしい・・・🙇

scatter plotでできたけど、縦横比が切なくなった。

scatter.spl
| makeresults count=2 
| streamstats count as x 
| eval x=if(x=1,0.00000,1.80000) 
| makecontinuous x span=0.001 
| eval tmp=mvrange(0,2) 
| mvexpand tmp 
| fields - _time tmp 
| streamstats count by x 
| eval x=if(count=2,-1 * x,x) 
| eval x_1=(1.5*exp(-0.62*pow(x-0.16,2)))/(1+exp(-20*(5*x-1))) 
| eval x_2 = (1.5+0.8*pow(x-0.2,3))*pow(1+exp(20*(5*x-1)),-1) 
| eval x_3 = (1+exp(-(100*(x+1)-16))) 
| eval x_4 = (0.2*(exp(pow(-(x+1),2))+1))/(1+exp(100*(x+1)-16)) 
| eval x_5 = (0.1/exp(pow(2*(10*x-1.2),4))) 
| eval y = round(x_1+(x_2/x_3)+x_4+x_5,4)
| sort 0 x
| table x y
| eval y_dash=exact(x), x_dash=exact(y)
| table x_dash y_dash
| sort 0 x_dash

OPPAI感がなくなったので、画像省略。(まんぼう　にみえるらしい)
OPPAIへの道は長い・・・