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.
Categories
- 10.8K All Categories
- 3 Private Company Board
- 1 APAC User Group
- 12 Welcome
- 39 Domo News
- 9.7K Using Domo
- 1.9K Dataflows
- 2.5K Card Building
- 2.2K Ideas Exchange
- 1.2K Connectors
- 343 Workbench
- 260 Domo Best Practices
- 11 Domo Certification
- 465 Domo Developer
- 50 Domo Everywhere
- 106 Apps
- 717 New to Domo
- 85 Dojo
- Domopalooza
- 1.1K 日本支部
- 4 道場-日本支部へようこそ
- 27 お知らせ
- 64 Kowaza
- 299 仲間に相談
- 654 ひらめき共有