I'm currently doing a weekly pull from Data Warehouse for our Data Engineering team that includes Transaction ID broken out by Marketing Channel interactions with Orders as the metric. They've asked that I add a layer that can give a definitive order to the channels viewed for each order. I tried a...