Hi everyone,
I am specifically trying to report on one season that has a performance every day as we are a museum. The tickets get tracked and sold after the actual performance in this case and therefore, the available dashboards through T-Stats only seem to allow me to show based on Order date which means that the results are totally skewed for our executives. Does anyone have a custom SSRS report or a creative way of showing sales based on Perf date instead of order date? (I thought of using the new attendance widgets, however, none of these tickets get scanned so the widget shows 0). Thanks for any ideas you might have!
I'm assuming you're referring specifically to the At-A-Glance Tickets widget? If you never want to use that widget based on order date, you (or you System Admin) can change it directly in System Tables, to make the At-A-Glance Tickets mimic what the At-A-Glance Attendance does.
In TR_DASH_WIDGET_PARM_VALUE there is a row for WidgetParameterDefinitionID named Date Hierarchy Name. If you change the DisplayValue and RawValue for your At-a-Glance Tickets widget to match the At-a-Glance Attendance, the Tickets version of the widget will use the Perf Dt instead. This will change the widget for everyone at your organization though, and will affect all existing dashboards, so if you're considering doing this, make sure what you want is truly "always instead".
That said, we don't generally recommend modifying the standard values in this table. You're welcome to make the change above, but if you're considering any others beyond that, it's best to contact the T-Stats and Dashboards support team before doing so.
Thanks! We actually have all the widgets installed twice...could I hypothetically modify one and rename it as suggested? Also, to confirm, this change will simply look instead for the Perf Date instead of Order Date, and will still look for tickets sold (not tickets scanned like the attendance widget)...correct?
I tried it out and it is working brilliantly! I now have a At-A-Glace Tickets widget (that works as normal) and a At-A-Glance Tickets (By Perf) widget (that pulls tickets sold based on Perf Date). Thanks a bunch, this is exactly what I was looking for!!
Derrek,
Is your organization in a consortium or do you otherwise have multiple divisions? If you do, then it would be expected that there would be more than one copy of each widget (one for each division). If you have unintentional duplicates, that was probably a mistake made during install, and we'd normally recommend your IT team reach out to support for guidance cleaning that up. That said, if you do have unintentional duplicates and wanted to repurpose one with the edits above, so you could do it both ways...yes, that should work. Correct, that changing the Date Hierarchy Name alone will not affect anything else about the widget: it would still reflect sales not scans.