I am trying to get the total count of ticket between submitted and Completed and also workdays W-6 to W-14
I am using the below code but am getting error , could you please help me how to get between W-6 AND W-14
WHEN ("_CEL_REMEDY_ACTIVITIES".WD_NEG=WD-6) BETWEEN ("_CEL_REMEDY_ACTIVITIES".WD_NEG=WD-14)
(
CASE
(CALC_THROUGHPUT(FIRST_OCCURRENCE[Submitted] TO LAST_OCCURRENCE[Completed],
REMAP_TIMESTAMPS("_CEL_REMEDY_ACTIVITIES".Task_end, Days))) > 5
THEN
1
ELSE
0
END
)
Hi Kaveri,
in order to help you, can you please provide more information here? How is the column WD_NEG defined? Is it connected with a timestamp? Are you using a workday calendar? If it is only a String in WD_NEG you can not use a function with between. You would need to single specify the Column entries in WD_NEG (WD_6 until WD-14) I guess. Furthermore, this condition need then to be incoopertated in your second statement with a CASE WHEN before calculating the Throughput.
Best regards,
Data Science Team
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
