Throughput Time between Null to First Set Delivery Block

Question

We are trying to build a dashboard to calculate throughput time between two activities.

Create SO Item with no block ( ')
First Delivery Block (ZX)
We are using the following PQL query is returning no values. Can you please guide us whether the pql query is correct?

AVG (DAYS_BETWEEN(
PU_FIRST(VBAP, _CEL_O2C_ACTIVITIES.EVENTTIME, _CEL_O2C_ACTIVITIES.ACTIVITY_EN = <%= start_activity_SO %> AND _CEL_O2C_ACTIVITIES.CHANGED_FROM = '),
PU_LAST(VBAP, _CEL_O2C_ACTIVITIES.EVENTTIME, _CEL_O2C_ACTIVITIES.ACTIVITY_EN = <%= change_dev_block %> AND _CEL_O2C_ACTIVITIES.CHANGED_TO = ZG)
))

kevin.flesc · Answer

Hi Muvva,it seems that you are missing some ' ' in the _CEL_O2C_ACTIVITIES.CHANGED_TO = ZG statement. This should be _CEL_O2C_ACTIVITIES.CHANGED_TO = 'ZG'. Additionally I assume in the _CEL_O2C_ACTIVITIES.CHANGED_FROM = ' you want to indicate that the CHANGED_FROM should be empty. This can be achieved by_CEL_O2C_ACTIVITIES.CHANGED_FROM IS NULLHope this helps.BRKevin

Reply

ANY QUESTION?

MORE CELONIS

CHECK US IN

Reply

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded

ANY QUESTION?

MORE CELONIS

CHECK US IN