• Replies 7 replies
  • Subscribers 412 subscribers
  • Views 317 views
  • Users 0 members are here
Related

Cumulative Donation Dashboard in Analytics

Benjamin Haller
$organization

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
  • $organization

    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

  • $organization in reply to Heath Wilder

    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

Reply
  • $organization in reply to Heath Wilder

    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

Children