I need to compare coupon sales with the total sales across dates to find out what percentage of customers used a coupon to purchase
I have a table grouped by a Coupon Name, with summed sales for all transaction's using that coupon. These sales are across multiple intermittent dates.
An example table is below:
I've tried various aggr and total combinations but some Coupons such as New10 have ran intermittently across random dates so I am struggling to find a formula that will match dates the Coupon was used and total orders correctly if that date had a coupon sale
Hope this makes sense, would appreciate any help, I'm using Qlik Sense.