How to figure out Pass/Fail status of test cases based on the info provided and display it in a bar chart?

[gpayal18]

Input to splunk is a CSV file which has columns as TestCaseID, ExpectedTime (Time which is expected for a test case to execute) and ActualTime (Time which test case has taken to execute). If Actualtime is <=ExpectedTime, then it is passed.
I want to figure out pass/fail test cases count by comparing ActualTime

[renjith_nair · Accepted solution]

@gpayal18 ,

Try

|inputlookup testcase.csv |eval TestStatus=if(Actualtime <=ExpectedTime ,"Pass",Fail")|stats count by TestStatus

If your Actualtime and ExpectedTime are strings, then convert them to epoch by using strptime(your_time_variable,"Your dateformat")

[gpayal18]

it worked.
Thanks a lot,

[renjith_nair]

@gpayal18 , Glad to know 🙂 . Please accept as answer to close the thread