Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Ok... I have this bar chart called Original Avg # Days in Routing, by Week that I need to change to use the dimension of ROUTING_WEEK_START instead of WEEK_START. Seems simple enough.
As you can see, these come from two different tables so I am unsure how to make this work. ROUTING_WEEK_START is part of a FACT table that is populated when a DEFECT_ID enters a PROCESS_STEP = "Submitted to Routing."
I created the CAL_ROUTING to see if I could make it work but it was unsuccessful.
Does anyone have any ideas?
Based on the qvw, it does not appear that the ROUTING_WEEK_START in the APP_ALM table is calculated for PROCESS_STEP values Routed and "Submitted to Routing".
Based on the qvw, it does not appear that the ROUTING_WEEK_START in the APP_ALM table is calculated for PROCESS_STEP values Routed and "Submitted to Routing".