Dashboards & Visualizations

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

gpayal18
Explorer

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

0 Karma
1 Solution

renjith_nair
SplunkTrust
SplunkTrust

@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")

View solution in original post

0 Karma

renjith_nair
SplunkTrust
SplunkTrust

@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")

View solution in original post

0 Karma

gpayal18
Explorer

it worked.
Thanks a lot,

0 Karma

renjith_nair
SplunkTrust
SplunkTrust

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

0 Karma
.conf21 Now Fully Virtual!
Register for FREE Today!

We've made .conf21 totally virtual and totally FREE! Our completely online experience will run from 10/19 through 10/20 with some additional events, too!