Hi,
We are looking to find a unique number of orders for under $100 for a season. We are hoping this can help us get an idea on offerings to certain patrons with orders under or over that amount. I see I can sort by paid amount under a certain amount, but I think my numbers are a bit inflated that way. I think I need to edit a formula on Order ID, just not sure how to quickly find it. We are looking to get this asap, so hoping someone has a quick answer!
Thanks!
If you want to do this in Analytics, start with a Pivot table so you can verify the results. To count the number of unique Order ID add Order ID to the Values and make sure the formula is COUNT([Order ID]).
On your Filters tab, Filter your Season and then add a Filter by Ticket Paid Amount <= 100 AND not = to 0 (to filter out free orders).
Thanks so much Neil! I will start working on this today.