Creating a Year-Over-Year Chart in Sisense

alexism or any other users in the future: here's another solution that doesn't rely on any custom SQL or modifying the eCube, and instead just uses the PREV/NEXT formulas.

I modified it slightly, for my purposes. If you use the current year as the baseline, you only see the months that've already occurred in the year (e.g. if it's February right now then your chart will only show January and February). Instead, I use last year as the baseline; this way we can see all 12 months in the chart. I'd set the date filter to Last Year, and then use the following formulas:

• CURRENT YEAR: ( SUM( [value] ) , NEXT( [date] , 12 ) )
• LAST YEAR: SUM( [value] )
• YEAR BEFORE LAST: ( SUM( [value] ) , PREV( [date] , 12 ) )

If you want to add more years, duplicate one of the NEXT/PREV ones and change the number to a different multiple of 12.