Skip to main content
Question

Throughput Time between Null to First Set Delivery Block

  • December 15, 2020
  • 1 reply
  • 3 views
.
Level 1
We are trying to build a dashboard to calculate throughput time between two activities.
  1. Create SO Item with no block ( ')
  2. 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) ))

1 reply

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

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 NULL

 

Hope this helps.

 

BR

Kevin

Community Code of ConductAccessibility statement