Forum Discussion
Analyzing PO Performance
Anonymous5 - Could you provide some sample data?
- Anonymous56 years agoRegular Visitor
Hi Nate,
Here's a sample of my query. Each row represents a PO created in 2019. The milestones occur along the way from it's preceding RFQ creation and approval through PO creation to receipt to delivery. I'd like my visualization to gather up all POs for a given quarter, average out the time spent at each phase and produce a horizontal stacked bar with 4 segments representing the following:
RFQ Creation - RFQ Aproval (days required)
RFQ Approval - PO Fiscal Effective Date (days required)
PO Fiscal Effective - PO Receipt (days required)
PO Receipt - PO Delivery (days required)
Thanks and Regards,
Rob
- Anonymous6 years agoNot applicable
- Anonymous56 years agoRegular Visitor
Hi Nate,
Which text are you referring to? All I've done so far is merge the tables using Excel Power Query and removed all the non-relevant columns for the sake of displaying here.
Rob