Creating a Year-Over-Year Chart in Sisense
Summary
This article addresses the issue of creating a year-over-year comparing chart in Sisense that shows a Key Performance Indicator (KPI) for the current calendar year against the previous calendar year. The chart should display KPI data for the current year's months that have passed and the full previous year.
Main Content
Steps to Create a Year-Over-Year Chart
-
Create a new normalized date column in the table where you have the date dimension. This can be done by duplicating the existing Date column and editing it.
2.Use the following query to create a new date column:
CREATEDATE( GETYEAR(NOW()), GETMONTH([Date]), GETDAY([Date]) )
3. After creating the new column, proceed to the dashboard and create a line chart with the required dimension.
4. Change the date formatting to "MMM" (or any desired format) and select the value you wish to compare.
5. Add the original date dimension as a break by with year granularity.
