Repeat visitors Creating #Constuients by a particular set of performance.

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:

• Edit a saved Widget and make no changes
• Edit the Widget Script (opens in a new tab)
• Save the Widget Script
• Return to the Edit Widget tab
• Refresh the browser page
• In 15.0 takes you to Welcome screen, browse to the dashboard and the widget reflects the script changes
• In 15.1 refreshes the Edit Widget screen and the widget reflects the script changes

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

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:

• Edit a saved Widget and make no changes
• Edit the Widget Script (opens in a new tab)
• Save the Widget Script
• Return to the Edit Widget tab
• Refresh the browser page
• In 15.0 takes you to Welcome screen, browse to the dashboard and the widget reflects the script changes
• In 15.1 refreshes the Edit Widget screen and the widget reflects the script changes

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.

Potentially silly question: where do I find the _Single_Ticket pre-built dashboard?