I have been editing the following query in order to get the duration for workload.....how ever while creating the visualization we only see duration of the bar chart......i am looking to see if we can get something with regards to the workload and/0r Jobname.
| inputlookup cyclestarttimes.csv
| lookup cycleendtimes.csv CYCLE WORKLOAD
| search WORKLOAD=F91
| where isnotnull(ENDTIME)
| eval STARTC = "2021-08-19"
| eval ENDC = "2021-08-20"
| eval STARTC = strptime(STARTC, "%Y-%m-%d")
| eval ENDC = strptime(ENDC, "%Y-%m-%d")
| eval CYCLEC = strptime(CYCLE, "%Y-%m-%d")
| where CYCLEC >= STARTC AND CYCLEC <= ENDC
| stats values(STARTTIME) as START values(ENDTIME) as STOP by WORKLOAD CYCLE
| eval _time = strptime(START, "%Y-%m-%d %H:%M:%S")
| eval end_time = strptime(STOP, "%Y-%m-%d %H:%M:%S")
| eval duration = (end_time - _time) * 1000
| eval JOBNAME = WORKLOAD
| stats count by _time,duration, WORKLOAD, JOBNAME
| table _time WORKLOAD JOBNAME duration
