Question
Variable filter on throughput time search
Hi all,
Im looking for a way to use variables to restrict the standard component " Throughput Time Search".
As an example:
I want the standard component to show me the average lead time of the process steps C-F.
I have tried a filter on the component and used the following code:
(CALC_THROUGHPUT(FIRST_OCCURRENCE[<%=dlz_start%>] TO LAST_OCCURRENCE[<%=dlz_end%>], REMAP_TIMESTAMPS(WFMT_EVENTS.TIMESTAMP, DAYS)))
Unfortunately the filter does not change anything. But I do not get an error message either.
Is my code wrong or does the standard component not provide this possibility?
Thanks for your help!
if I understand correctly the above formula is your filter statement? In case that assumption is right you need to create a condition saying FILTER [your_statement] > 5 e.g. in case you want to say this TPT needs to be larger than 5. In case I am understanding this incorrectly can you please try to elaborate further.
Best
Kevin
+2Hello Lisa,
You've missed the filter condition . I've tested the formula below and it is working
FILTER
CALC_THROUGHPUT(
FIRST_OCCURRENCE [<%=dlz_start%>] TO LAST_OCCURRENCE [<%=dlz_end%>],
REMAP_TIMESTAMPS(
WFMT_EVENTS.TIMESTAMP,
DAYS
)
)
>= 1;
Best,
Gabriel
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.