I am looking at Single ticket sales, by Production, by DOW, by time slot...strange thing is that I keep getting productions coming up which show sales in Monday matinees. which we do not have...when i layer in Constituent IDS (so I can try to figure out why these patrons are showing where they are) the orders are definitely not for Monday afternoon performances...they seem to be all over, in terms of DOW.
I know there are many ways to pull this info so I am thinking, for some reason, I am just pulling in the wrong parameters?
I look to you all becasue I am racking my brain and it is very tired.
I know you know this, but just in case your brain is really tired...are you positive that your column showing DOW isn't pulling Order Date DOW instead of Performance DOW?
I'd agree with Nicole. You can also use "Performance Date and Code Short" and the endings will tell you whether its a Evening or Matinee Show. Its not as clean but it should help you iron out the problem
Brian Barry (Past Member) I took your suggestion and stripped out TIme Slot and put in Perf Date and Code Short. stays weird. below, in the screenshot, the performances listed under Sunday are definitely Sundays...but, when you look below that on Mondays I also see somoe of the same performances.
Do you mind sharing your dashboard? I just duplicated it on my end and everything seemed to work just fine
not at all. I appreciate the assistance and look forward to the simple mistake I am making
https://NASWANAWP010.tessituranetworkramp.com:443/app/main#/dashboards/5e3c89f4ae0f1b1814734bb7
Could you Export it as a .dash file and send that? I can't access that link, unfortunately
Erik Schnitger,
I don't believe that the link you shared above is accessible by any of the folks on this thread who are not part of your organization.
You can share a dashboard with the rest of us by Exporting the dashboard and posting the .dash file.
https://www.tessituranetwork.com/Help_System/Content/Tessitura%20Analytics/Sharing%20and%20Printing/Exporting%20a%20Dashboard.htm
Here is a thread where we were talking about sharing dashboards and some of the challenges that can come up.
https://community.tessituranetwork.com/topical_groups/analytics-coffee/f/discussions/22034/sharing-dynamic-pricing-template/63367#63367
thanks. a bit green still
3036.STsalesbyDOW.dash
Looks like you're using "Attended Date - Day of Week Sort". If you use "Performance Date - Day of Week Sort" that should fix it. There are 8+ "Day of Week Sort" options and they pull different data points, which makes it kind of confusing
holy hell that was it...I swear I put in every possible DOW option...guess not. Thanks to all. what a wonderful community.