How to get values and sum between a and b

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

Thanks for responding …am able to resolve the same