Skip to main content
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!

Hi @lisa.schad11 

 

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


Hello 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