I'm trying to figure out how to find out how many tickets were refunded, exchanged, and donated between the time we canceled due to COVID. Is there a report or a dashboard I could use to get that information?
What I find is tricky is the corner cases such as: first said on account and then changed to donation, or moved money to on account before shifting it to donation. I'm finding that doing it in SQL using BI.VT_TRANSACTION_AND_PAYMENT is helping me understand the dashboard filters and values better.
Hi Heath,
Please don't think me dim, but I've been staring at my dashboard since I've read your reply, and I have to confess, I'm not familiar with SQL. Would you mind telling me where I can get started? Thank you!
You could use https://www.w3schools.com/sql/ as a good base-line and YouTube. Tessitura uses TSQL.
Also, look at previous TLCC presentations regarding SQL.
Hey Shakera, No you are DEFINITELY not dim. SQL is a real world unto itself. I think that taking baby steps in that only if you need to. Just for my wacky brain it's a little easier for me to understand some of the Analytics Finance cube by looking at the finance tables (ie: big spreadsheets in the database) and filtering them.There have been a few posts recently on refunds and returns ... have they been helpful? Chris's stuff really helps in negotiating the Finance Cube in Analytics which is where all those calculations need to be done.When I get a sec I'll have a look at the question you asked Jeremy. That's something I should answer as well.
Thanks Heath! My apologies for the tardy response!