Skip to main content

Hi all,

 

I am wondering if I could give default value in the component Throughput Time Search other than using Filter.

Do you have any idea to set following criteria e.g. as below so that the analyst confirm the crop selection is applied to this component?

image.pngimage.png

Hello Tomoki,

 

You can set up the values in the Selection panel with Throughput Time Selection likewise:image 

Let us know if this helps


Hello Tomoki,

 

You can set up the values in the Selection panel with Throughput Time Selection likewise:image 

Let us know if this helps

If you want to apply the filter to just one component you can set up the filter in the PQL:

 

CALC_THROUGHPUT(

ALL_OCCURRENCE C'Process Start'] TO ALL_OCCURRENCE C'Process End'],

REMAP_TIMESTAMPS(

"_CEL_P2P_ACTIVITIES_EN"."EVENTTIME",

DAYS

)

) BETWEEN 0 AND 10

 

 


Hi Erol,

 

Thank you for your suggestions.

What I want the default value here not as Process Start / Process End but Create Sales Order / Create Invoice for example.

I understand that we could technically filter the time range using `OCCURENCE` , but what I exactly want to achieve is to clearly show the range of throughput time shown in this component for analysts.

 

image


Hi Erol,

 

Thank you for your suggestions.

What I want the default value here not as Process Start / Process End but Create Sales Order / Create Invoice for example.

I understand that we could technically filter the time range using `OCCURENCE` , but what I exactly want to achieve is to clearly show the range of throughput time shown in this component for analysts.

 

image

It was just an example, as I don't have Your data. In Your case it can be done the same with "Create Sales Order" and "Create Invoice".

You can change the variables in the visual selection instead of "Process Start" and "Process End" to match any activity You want, same can be done with PQL:

 

CALC_THROUGHPUT(

ALL_OCCURRENCE C'Create Sales Order'] TO ALL_OCCURRENCE C'Create Invoice'],

REMAP_TIMESTAMPS(

"_CEL_P2P_ACTIVITIES_EN"."EVENTTIME",

DAYS

)

) BETWEEN 0 AND 10

 

And if You wish to create a new component with plots of actual throughput time, simply create a histogram plot with the PQL:

CALC_THROUGHPUT(FIRST_OCCURRENCEE'Create Sales Order'] TO FIRST_OCCURRENCEE'Create Invoice'], REMAP_TIMESTAMPS("Your_Activity_Table"."EVENTTIME", DAYS))

 

 


It was just an example, as I don't have Your data. In Your case it can be done the same with "Create Sales Order" and "Create Invoice".

You can change the variables in the visual selection instead of "Process Start" and "Process End" to match any activity You want, same can be done with PQL:

 

CALC_THROUGHPUT(

ALL_OCCURRENCE 'Create Sales Order'] TO ALL_OCCURRENCE 'Create Invoice'],

REMAP_TIMESTAMPS(

"_CEL_P2P_ACTIVITIES_EN"."EVENTTIME",

DAYS

)

) BETWEEN 0 AND 10

 

And if You wish to create a new component with plots of actual throughput time, simply create a histogram plot with the PQL:

CALC_THROUGHPUT(FIRST_OCCURRENCEC'Create Sales Order'] TO FIRST_OCCURRENCEC'Create Invoice'], REMAP_TIMESTAMPS("Your_Activity_Table"."EVENTTIME", DAYS))

 

 

Thanks, I understand that the same logic is achievable in PQL customization.

What I want is the component to give the text of "Create Sales Order" and so on as the default value, not the "Process Start"

They always show Process Start -> Process End everytime you reload the screen, right? I want them to choose certain Activity every time analyst login to their dashboard.

Would you say that is impossible and need to create histograms instead?


The default is always Process start and end, if You want a custom selection for Your dashboard, a solution can be done with a dropdown with Your activities as shown here in one example:

 

image


The default is always Process start and end, if You want a custom selection for Your dashboard, a solution can be done with a dropdown with Your activities as shown here in one example:

 

image

Thanks Erol, thank you for your idea.


Reply