Hai the code which u have given is showing some error,
So i will provide u the search query for open that is
source="/home/Techm/Desktop/OMS data/TABLE_X_I_WP_TASK1.csv" X_STATUS="Execution" X_I_WP_TASK2SUBPROJECT=$X_I_WP_TASK2SUBPROJECT$ | table X_I_WP_TASK2SUBPROJECT,X_ACTUAL_START_DATE,X_COMMITTED_END_DATE,X_COMMITTED_START_DATE,ID_map | rename ID_map as TASK_NUMBER | join TASK_NUMBER [search source="/home/Techm/Desktop/OMS data/CLASSIC_TASK_NAMES.csv"] | table TASK_GROUP,TASK_NAME,X_I_WP_TASK2SUBPROJECT,X_ACTUAL_START_DATE,X_COMMITTED_END_DATE,X_COMMITTED_START_DATE | eval j2=X_COMMITTED_END_DATE | eval j1=X_COMMITTED_START_DATE | eval d1=strptime(j1,"%d-%b-%y") | eval d2=strptime(j2,"%d-%b-%y") | eval X = (d2-d1)/86400 | eval k2=X_COMMITTED_END_DATE | eval k1=X_ACTUAL_START_DATE | eval c1=strptime(k1,"%d-%b-%y") | eval c2=strptime(k2,"%d-%b-%y") | eval Y = (c2-c1)/86400 | eval Delay=(X-Y) | where Delay>1 | rename Delay as "DELAY IN COMPLETION OF TASK" |join TASK_GROUP [search source="/home/Techm/Desktop/OMS data/AVERAGE_CLOSE_TIME3.csv" NOT "Avg_Close_Time"] | rename EXPECTED as "EXPECTED DAYS REQUIRED TO COMPLETE THE ORDER" | table TASK_GROUP,TASK_NAME,"DELAY IN COMPLETION OF TASK","EXPECTED DAYS REQUIRED TO COMPLETE THE ORDER" |rename TASK_GROUP as "PRIMARY TASK"|rename TASK_NAME as "SUB TASK"
search query for closed is
source="/home/Techm/Desktop/OMS data/TABLE_X_I_WP_TASK1.csv" X_STATUS="Ended" X_I_WP_TASK2SUBPROJECT=$X_I_WP_TASK2SUBPROJECT$ ID_map!=" " | table OBJID,ID_map,X_ACTUAL_START_DATE,X_COMMITTED_END_DATE,X_COMMITTED_START_DATE,S_X_TASK_ID,S_X_DESCRIPTION,X_I_WP_TASK2SUBPROJECT | rename OBJID as CONTRACTID |rename ID_map as TASK_NUMBER | join TASK_NUMBER [search source="/home/Techm/Desktop/OMS data/CLASSIC_TASK_NAMES.csv" TASK_NUMBER!=" "] | table CONTRACTID,TASK_NUMBER,S_X_TASK_ID,TASK_NAME,TASK_GROUP,X_I_WP_TASK2SUBPROJECT,X_ACTUAL_START_DATE,X_COMMITTED_END_DATE,X_COMMITTED_START_DATE | eval j2=X_COMMITTED_END_DATE
| eval j1=X_COMMITTED_START_DATE
| eval d1=strptime(j1,"%d-%b-%y")
| eval d2=strptime(j2,"%d-%b-%y")
| eval diff = (d2-d1)/86400 | table CONTRACTID,TASK_NUMBER,S_X_TASK_ID,TASK_NAME,TASK_GROUP,X_I_WP_TASK2SUBPROJECT,diff | stats avg(diff) as Avg_Close_Time by TASK_GROUP
can u provide the detailed code using this search queries......
... View more