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?
Best answer by erol.mrzic
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:
Hello Tomoki,
You can set up the values in the Selection panel with Throughput Time Selection likewise:
Let us know if this helps
Hello Tomoki,
You can set up the values in the Selection panel with Throughput Time Selection likewise:
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 ['Process Start'] TO ALL_OCCURRENCE ['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.
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.
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_OCCURRENCE['Create Sales Order'] TO FIRST_OCCURRENCE['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_OCCURRENCE['Create Sales Order'] TO FIRST_OCCURRENCE['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:
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:
Thanks Erol, thank you for your idea.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
