Is it possible to set 12 complete months rolling date range?
I need to show completed months data only in a rolling 12 month cycle. Is this possible using date range filters? "Previous 12 months" includes current month which is incomplete and not required. I'm using between dates at the moment but this means I have to remember and change them the beginning of every month.
Best Answer
-
For reference here's a beast mode I like to use with LAST_DAY to determine if the date value is in the current month.
CASE WHEN LAST_DAY(CURRENT_DATE) = LAST_DAY(`date`) THEN 'Current Month' ELSE 'Not Current Month' END
LAST_DAY returns the last day in the month for a given date. CURRENT_DATE returns the current date
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Answers
-
you can set it to the last 13 months and then use a beast mode to calculate if any dates are doing the current month and exclude them with a filter.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**2 -
Hi @GrantSmith , that sounds like a great solution! I'll work on my beastmodes and get back if I need any additional support. Thanks for your super quick response 😊
0 -
For reference here's a beast mode I like to use with LAST_DAY to determine if the date value is in the current month.
CASE WHEN LAST_DAY(CURRENT_DATE) = LAST_DAY(`date`) THEN 'Current Month' ELSE 'Not Current Month' END
LAST_DAY returns the last day in the month for a given date. CURRENT_DATE returns the current date
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
Thanks Grant, input the formula into my cards and working well!!😄
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive