Create a Plot chart with a month-over-month comparison of the values [Linux]
Easy way to compare all values month-over-month
Step-by-Step Guide:
1. Create a new normalized dim date table and connect it to the date dimension. This can be done by duplicating the existing Date column and modifying it.
2. We will use the following query to create the columns we need.
select
date,
GetYear([date]) as yeas,
GetMonth([date]) as month,
CASE GetMonth([date])
WHEN 1 THEN 'January'
WHEN 2 THEN 'February'
WHEN 3 THEN 'March'
WHEN 4 THEN 'April'
WHEN 5 THEN 'May'
WHEN 6 THEN 'June'
WHEN 7 THEN 'July'
WHEN 8 THEN 'August'
WHEN 9 THEN 'September'
WHEN 10 THEN 'October'
WHEN 11 THEN 'November'
WHEN 12 THEN 'December'
else ''
end as month_text
from Commerce group by date
3. Connect the tables by the Date column
4. When we create a new column, we need to build the elasticube. The table will look like this.
5. After this, let's go to the dashboard
6. Add month_test column (from DimDate) as a category, Values, and the original date dimension as a break by with year granularity.
7. As a result, we can get the following Plot chart
Conclusion:
This technique you can use to create a different chart or Pivot with a month-over-month comparison.
References/Related Content
- https://community.sisense.com/kb/faqs/creating-a-year-over-year-chart-in-sisense/21555
Disclaimer: This post outlines a potential custom workaround for a specific use case or provides instructions regarding a specific task. The solution may not work in all scenarios or Sisense versions, so we strongly recommend testing it in your environment before deployment. If you need further assistance with this, please let us know.
