Hello,
I'm not sure where I found this widget, but I'm guessing it was here. I'm looking to report on the percentage of TNEW orders that include an add-on cart donation. We have a specific fund for these, so it should be easy enough. However, my widget is saying 100% and I know that isn't correct. Any ideas?
Eventually, I'll add a filter to specify the date range, but I thought I'd start with all to refine the parameters. Dash is attached.
Thanks!Anne
OrderswithContributions.dash
Right now, the filter on the right is only including orders that are in the add-on fund. I think if you remove that so that you are filtering to all web orders and then filter within the formula to those that have the add-on fund you'll get closer to what you're looking for.
Well, that certainly explains the 100%! Ha! But I can't seem to figure out how to filter in my formula:
I'm not familiar with this transaction category parameter. Is it not working with what you have selected? I wonder if that's a customization or if I just have never tried to use it. You could try deleting it and using your fund instead? I'm not sure. Of course Tess won't open for me right now.
I'll admit I'm not familiar with it either! I feel like I must have imported this from somewhere. The number I'm getting is way too high.
I thought I had it, but my number seems way off.
I just looked at transaction category in my database and was surprised to see most of ours fall into the membership in order category. Are you selecting only the contribution in order? Have you looked at the data in a pivot like this?
I just output it as a pivot and the numbers seem way off. It is only 24 orders without a contribution and I know that is WAY off. Chris Wallingford -- do you have any ideas? or should I put in a ticket for this one?
Hi Anne,
I suggest we walk this back a bit...
With just the dashboard date filter and the widget mode of sale filter, change the value to simply
[# of unique Order ID]
Does that value look correct for the total count of web orders, regardless of whether they contain a contribution?
If so, add the widget filter (not value filter) for Fund back on and see how the count of orders changes. Does this value look reasonable?
If so, update the value to this formula:
[# of unique Order ID] / ( [# of unique Order ID] , ALL( [Fund] ) )
Hi Chris, Thanks for getting back to me so quickly! The total count of orders does not look correct. It seems very low for the time period I have selected. Looking at the MOS analysis report (which I haven't used before and I'm a bit confused by how many incomplete orders are showing up), we should have more than 900 orders. But the widget is giving me 271.
I'm sorry to hear that. Let's start there though, with a support ticket to resolve your alignment between MOS Analysis and Analytics. I will say that order counts in that report are ... not clear. It double counts orders in subtotals that appear on multiple season or performance rows. E.g. when I run mine locally, grouped by season, all the season level numbers are the same as my Analytics widget, but the report order count for the mode of sale is 774, while Analytics is 583. From help:
Note: If an order has seats in multiple categories, it will be counted in multiple category order totals. As such, the order totals from each category should not be manually summed because the resulting total will likely count some orders more than most, reflecting an inaccurate total.
ModeofSaleAnalysis.dash
Thanks, Chris. I just put in a help ticket.