Cumulative Donation Dashboard in Analytics

Hey all,

Looking for any examples of cumulative dashboards for data (ie a nice-looking graph, chart that shows the running tally of donations for the year).

Let me know anything you are willing to share and how it is configured in Analytics.

Thanks

Ben

Parents
  • 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

  • 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
Reply
  • 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
Children