Hey,
I want to measure the lead time between two activities, but which must contain a certain (variable) attribute.
I tried this with the function "BIND_FILTERS" but fail. Does anyone have a solution for something like this?
MEDIAN (
CALC_THROUGHPUT (
FIRST_OCCURRENCE E '<%= Step_1 %>' ]
TO
FIRST_OCCURRENCE C '<%= Step_2 %>' ] ,
REMAP_TIMESTAMPS ( "_CEL_SCHUTZBRIEF_ACTIVITIES"."EVENTTIME" , MINUTES )
),
BIND_FILTERS ( "_CEL_cc_claim","ANS_KNZ_Mapping_csv"."ANS" = '<%= ANS_01 %>' )
)
Hello Daniel,
It depends when and how you want to utilize this formula:
1) You can try use CASE WHEN in addition to CALC_THROUGPUT
2) Include FILTER Statement on analysis / component level
Bind filter statement should be used with mutliple filters used with "AND" statement.
Below sample code:
1) <aggregation>
CASE WHEN "_CEL_CASES"."DOCID" = 2859131 THEN
0
ELSE
CALC_THROUGHPUT (
FIRST_OCCURRENCE R 'A' ]
TO
FIRST_OCCURRENCE _ 'B' ] ,
REMAP_TIMESTAMPS ( "_CEL_ACTIVITIES"."EVENTTIME" , MINUTES )
)
END
B) FILTER "_CEL_CASES"."DOCID" = 2859131
Hope it helps :)
Best Regards,
Mateusz Dudek
Thanx!
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
