Given a set of process data that determines a time in process using pull up aggregation, I would like to generate the different time in process averages for an attribute for 1st quartile, 2nd quartile, 3rd quartile, and 4th quartile attributes.
Remember the average time in process is calculated via pull-up aggregation, which I believe means I can't run pull up aggregation on it again. I tried to research Domain Tables, but I wasn't sure how to apply them here.
see image for example:
Hi Matt,
Thank you for your question.
There's a PU_Quantile function that can help you with calculating the quartiles. I would recommend you to please take a look at the documentation of the PU_Quantile function.
Domain table can be understood as temporary tables that you can include within your PU_Quantile function, please take a look at the documentation as well here to learn more about it and see whether it is necessary to use it.
The PU_Quantile and Domain table functions can both be used within a standard aggregation function such as an AVG function.
Hope this helps with guiding you in your calculation! If not, please elaborate further with a screenshot of your code on which part you are exactly facing an issue with.
Thank you.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
