Create a Custom Calendar and add to filter section for users

We report mainly off a custom 4-4-5 Calendar.


Monday - Sunday Weeks

Months(Periods) are Monday - Sunday groups of 4, 5, or 6 Weeks. 6 Week Month's only happend every 5.6 years (Period/Month 12) when there are 53 weeks in a Fiscal Year. This creates a period of up to 42 days in the "Month."

Years are Monday - Sunday.


Basically, this calendar keeps a full week (Mon-Sun)  intact and creates logical groupings of weeks to compare like periods year over year.


If the option does not exist yet, it would be awesome to be able to upload our custom Fiscal Calendar and use it as the filtered range. 


What I will be exploring is writting a CASE WHEN beastmode calculation to check the current date, find the fiscal date that matches, and then have it set ranges for "Relevant Data" year over year using the Custom Periods and Years... Hard to explain.


Attached is an example for Fiscal Years 2015 to 2018.

1 votes

· Last Updated

This discussion has been closed.