Like this:
| index = *
| stats count(search) AS "total_count" SPLITROW Test_ID SPLITROW R_S_Me SPLITROW Set SPLITROW Created_Date
| eval targ_met = if(R_S_Me="Y", 1, if (R_S_Me="N", 0,-1))
| eval resp_per = ((targ_met/total_count)*100)
| eval Month = strftime(strptime("01-".'Created_Date', "%d-%b-%Y"),"%b%Y")
| streamstats dc(Month) AS _serial
| eval Month = case((_serial==13), Month,
(_serial==12), " " . Month,
(_serial==11), " " . Month,
(_serial==10), " " . Month,
(_serial==9), " " . Month,
(_serial==8), " " . Month,
(_serial==7), " " . Month,
(_serial==6), " " . Month,
(_serial==5), " " . Month,
(_serial==4), " " . Month,
(_serial==3), " " . Month,
(_serial==2), " " . Month,
(_serial==1), " " . Month)
| chart avg(resp_per) as "Response Metric" OVER Set BY Month
... View more