Forum Discussion
Solved
Datediff ROWS - 1 order, 8 steps. 3 critical columns: order #, date/time, step name
This data is interfaced with an app and is returned as the below: Woe_orderno is the order #. I have over 20,000 orders. I want to build a matrix that shows each order and the time it took for ...
This is resolved. It was correct to pivot, but I was "unpivoting" when I should have first "pivoted" then "unpivoted." That solved my layout and I could write the measures for the datedif (as they were not in sequence). Thank you all.
This is resolved. It was correct to pivot, but I was "unpivoting" when I should have first "pivoted" then "unpivoted." That solved my layout and I could write the measures for the datedif (as they were not in sequence). Thank you all.