Cumulative Donation Dashboard in Analytics

Hi Ben,

This is a fun running sum graph to compare Year on Year.
It's in my 2020 COVID exporation dash which is more of a renewals thing

What I really want to do is put pointy arrows on all the big jumps and indicate the appeal or event that caused them

That IS fun, Heath,

And if you are okay with hardcoding those appeals and events into the widget, it's doable...

It requires NOT using a Break By, because Break By limits the chart to a single Value, so you'd need to switch to using a discrete value for each of those 2 years, and then an additional value for each appeal/event. This could make for a weird looking legend... or an amazingly informative one... depends :) 

IF ( [Max Order Weeks Since OnSale] = 10 , 300000 , NULL )

And then from the options menu for that Value, set the Series Type to Column. Make in the "top" value in the list of values, above all the others in the Values panel, so that the column renders behind the lines. Then rename it the name of the appeal/event which will appear in the tool tip and legend.

I used a hardcoded 300000 in the example above, to get a column height that seemed appropriate, but you could also grab a more relevant height from the data... like the Total Received Amount where the Days Since Campaign Start <= 125... (e.g. formula from Seats and Tickets)

IF ( [Max Order Weeks Since OnSale] = 10 ,
( [Total Ticket Paid Amount] , [Order Weeks Since OnSale <= 11] )
, NULL )

Cheers,
Chris

How do you keep the line unbroken like that? When I tried to replicate this with the same data points, I get something that looks like this instead:

Hi Brian,

If you duplicate the pre-built Production Sales dashboard, and edit the Running Sales Total by Weeks Since Onsale widget, and then from the Options menu, select Edit Script. 

This will open a new tab if you're in a web browser, or an external window in the Tessitura application. You'll find this code that forces connection of series points across empty results:

widget.on("beforeviewloaded",function(scope, args){
args.options.plotOptions.series.connectNulls = true;
});

So you could just drag this widget from your duplicate copy of the Production Sales dashboard onto your bespoke, Seats and Tickets based dashboard, and then edit it to show the fields you wish. Or, if you're creating a curve in the Contributions cube... 

1. copy that code to your clipboard
2. go to your own widget, edit it, and without making any changes to the widget, open the Edit Script page
3. paste the code into the Edit Script page, and click Save (you receive a prompt that it's been saved)
4. click back to the Edit Widget screen and 
   1. if in the desktop application, right-click and select Hard Reload
   2. if in the web application, refresh this page
5. click Apply on the Edit Widget screen

I got this script from the always amazing Ragan Rhodes about 12 months ago

Edit widget >> Ellipsis (top right) >> Edit Script and paste in the following code

widget.on("beforeviewloaded",function(scope, args){ args.options.plotOptions.series.connectNulls = true; });

EDIT: oops Chris beat me to it (my shocked face = )

oooh I love this (As will my Marketing team) 

Off to play with my line graphs.

Grazie Mille

It's beautiful now; thank you Chris Wallingford and Heath Wilder!