Skip to main content
DD-APY-003 Mizan Group: The Life of a Supplier Invoice — Accounts Payable & Payments Get the data →
DD-APY-003-Q050 Very Hard Time series

Posted within two working days

An invoice's received time is the EventTimestamp of its "Received" event, its posted time that of "Posted", and its paid time that of "Paid" or "Manual payment". For invoices received in December 2025, count the working days after the received date up to and including the posted date (the date of the "Posted" event; Monday-Friday, not a DimHoliday date). What percentage were posted within 2 working days? 2 decimals.
Expected
One percentage, 2 decimals · KPI card
Tables
FactInvoiceEvent, DimHoliday · columns
  • FactInvoiceEvent
  • DimHoliday
  • InvoiceID
  • Activity
  • EventTimestamp
  • UserID
  • HolidayDate

Discussion

No one has posted here yet. Ask something, compare your result, or share how you solved it.

A free account takes a minute. Your draft is kept while you sign in. Need help? Message us