Hi There,
I am trying to help our Group Sales Manager put together a widget that shows the total ticket sales $, total fees paid $, and how many fees have been paid #, by performance and source in our 2223 Season. I am having quite a bit of trouble getting a widget put together for this purpose, and thought I would throw this subject out there to see if the Analytics Brain Trust has any suggestions, or if someone else has already successfully created a widget like this.
Please let me know if I can answer any questions to clarify the need.
--Tiffin
Hey friend! I'm happy to hop on a call and talk through this with you.
(Assuming Per Seat fees) It's really tricky due to fees being attached at the order level in Analytics.
My thought is it's possible to create an SSRS report using T_SLI_FEE - I think would be a mod of the Fees By Performance Report (RP_FEES_BY_PERF) with # Tickets sold by Source. Trick might be whether or not the System Never Deletes box if checked in case the subline Item is ever deleted. Lucky that base is covered in the above report.