All,
We have a particular set of performances we call LSC After Dark.
I'd like to use Tessitura Analytics to report how many folks we have who have attended just one performance/event for that production, How many attended 2, 3,4,5,6...
I'm wondering if anyone has used Tessitura Analytics to create this type of graph.
Here is how far I've gotten so far.
It looks like I need to count non-null values from the pivot above.
Thoughts?
--Tom
cc: analytic Coffee!
So, I'm a little bit closer.
I have not yet figured how to count customers by a calculated value. Or if that is even possible.
Hi Tom,
Have a look at the _Single_Ticket pre-build, the Number of Performances by Customer widget. This uses "dynamic buckets" to group constituent counts by their count of performances. There is undocumented code behind this widget (were you to edit the widget and select edit script), so might be best to drag a copy of the widget onto another dashboard rather than attempting to build one from scratch.
On your copy then change the filters and count of performances value as needed, and then edit the code behind. There are 2 types of bucket ranges that you can define:
A) Manual Ranges: Allows you to manually define the buckets ranges.B) Dynamic Ranges: Allows you to define the number of buckets. Ranges will be calculated automatically by the Min and Max of the widget values.
Using this plugin is a little tricky. The process for applying a script change to a widget is typically:
However, in 15.1, for dynamic buckets specifically, after refreshing the Edit Widget screen, the results will look very strange. That's okay. Click Apply, and then over to another dashboard and back, and the widget should then render in buckets.
Bucketing.dash
Best,Chris
Thanks, Chris Wallingford this looks very helpful. But something that will take a bit of digging into. When I have a moment, I'll dig into this and report back to the group.
Thank Chris.
I've learned how to copy a Widget from one Dashboard to another. You have to grab the Widget Header and drag the widged to the name of the name of the second dashboard in the list on the left. The copy ends up at the bottom of the dashboard you dragged the widget to.
You can't copy a widget from one Dashboard in one window to a different dashboard in a different dashboard window. (Once you understand how it works it works smoothly.)
So Chris Wallingford,
This is very close. I'd really like to count dates attended. Here at a museum, it is often likely that a customer buys multiple performances for use on the same date. (General Admission + the Planetarium + ...)
Has anyone sorted out how to count things by unique performance dates? My guess is that I have to change the dates somehow into strings, rather than continuous dates.
I believe you should be able to edit that widget, remove the COUNT([Performance ID]) and replace it with COUNT([Days in Date]), by select the Date field of the PERFORMANCE DATE collection...?
When you first put in the value. You think that you did it wrong. You end up with a graph like this.
However, If you Trust. Save the report, And re-fresh you end up with something more like this.
Still, need to do a bit of testing...
Thanks, Chris Wallingford!
Here is what I have so far.