Skip to main content
Question

Variable filter on throughput time search

  • September 25, 2020
  • 2 replies
  • 20 views
L
Level 0
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!

2 replies

K
Level 0
  • kevin.flesc
  • Level 0
  • November 22, 2021

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

gabriel.okaba11
Celonaut
Forum|alt.badge.img+2

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

Gabe
Community Code of ConductAccessibility statement