Compare last year's ticket count to this years ticket count by month

I've not worked this out yet.  However, I'd like to figure this out at some point.

If I get something working for this.  I'll drop a note here.

Has anyone else sorted this out?  This kind of calculation is used in Membership Donations, and Museums a lot.  Where our comparables, are from the same period last year.

Hi Kristine,

There a few functions for looking at past period information as you've noticed. Here I have the Date field from the ATTENDED DATE collection, grouping at the Month level. For context, the first two values show the Attended Count in that month, and the Past Year Attended Count showing the Attended Count from that month 1 year prior (note Attended Count in 6/2016=21 and Past Year Attended Count in 6/2017=21). Then the next two columns for Growth and Difference are a percentage and subtraction calculation between the Attended Count and the Past Year Attended Count for a given Attended Date.

CompareLastYearbyMonth.dash

Best,
Chris

Chris,

This is great.  I've been able to move this to tickets by performance date.

Thank you!!! This is great.

I've reproduced this pattern for a number of usage including making this into some Line Graphs.  

Questions:

• Anyone know if Sisense has the ability on a line graph to select a second axis.  (I've got some precents, Then look like a straight line when compared to Hundreds or thousands of tickets?
• Anyone know if you can change the time scale from Months to Days or weeks.  Things like:
  • This week this year compared to same week last year
  • This week day of the week compared to last week same day of the week.

What about doing this for comparing an entire fiscal year with the prior fiscal year? The DIFFPASTYEAR function requires that the Pivot be segmented on some sort of date, but "Fiscal Year" is an integer, and that's what I want to segment on. Thanks!

-Galen