• Replies 2 replies
  • Subscribers 962 subscribers
  • Views 308 views
  • Users 0 members are here
Related

Graphing YOY Sum Contributions, stacked Fiscal Years

Natalie Groom
$organization

Hello! 

I'm new to my organization and new to Analytics. I am trying to graph Year-Over-Year cumulative contributions with a window of September-August (our fiscal year, so not by calendar year). I've spent hours noodling and can't figure it out! Any ideas would be welcome.

In this graph I was able to see all FY cumulative contributions side-by-side but not stacked:

In this graph I can achieve a stacked line graph, but the months are in alphabetical order.

Then I can get a bar chart that has correct months but must not be showing cumulative contributions, otherwise the colors would all be trending upwards towards the close of our fiscal year

Parents
  • $organization

    Hi Natalie,

    For the month sort try adding Calendar Month Sort over the Month to organise

    However this might be worth a look (it's something I whipped up for another org)

    • X axis is days since campaign start 
    • Values are RSUM([Total Recieved Amount])
    • Break by is Campaign Fiscal Year
    • And filter is Campaign

    Let me know if you want the .dash file to look at

Reply
  • $organization

    Hi Natalie,

    For the month sort try adding Calendar Month Sort over the Month to organise

    However this might be worth a look (it's something I whipped up for another org)

    • X axis is days since campaign start 
    • Values are RSUM([Total Recieved Amount])
    • Break by is Campaign Fiscal Year
    • And filter is Campaign

    Let me know if you want the .dash file to look at

Children
No Data