Calculate the number of days that an event take place
I have a giant data set with Order number, profit, coupons, campaigns etc. I have categorized each order's promotion campaign. Now I want to calculate the profit per day for each campaign so I can make effective comparisons, but I don't really know how to use beast mode for this. I have a column of order data as well. I…