What's the beast mode to show only the current month and next month?
Hi, need help to show only the current month and next month from my schedule data, but the current month should starts with the 1st day of the month. For example, my pivot table should show only May and June. I have the below beast mode that I put in filter and filter by 'SHOW' to get only May and June but the problem is the data starts from May 15 since I'm using Curdate formula, I can't find any formula that will result to show only data from May 1 to June 30
CASE WHEN Date
<= DATE_ADD(CURDATE(), INTERVAL 2 MONTH) and Date
> DATE_SUB(CURDATE(), INTERVAL 0 MONTH)
THEN 'SHOW'
ELSE 'HIDE'
END
Best Answer
-
@david_cunningham This is exactly what I need. Thank you so much, appreciate your help.
0
Answers
-
@Zofia here you go!
The way this works is that we compare the month and year of the date to the month/year of the current date. We use date_add to add a month. This should work across year changes as well.
CASE
WHEN MONTH(CURRENT_DATE()) = MONTH(date) and YEAR(CURRENT_DATE()) = YEAR(date) then 'Show'
WHEN MONTH(DATE_ADD(CURRENT_DATE(),INTERVAL 1 MONTH)) = MONTH(date) and YEAR(DATE_ADD(CURRENT_DATE(),INTERVAL 1 MONTH)) = YEAR(date) then 'Show'
ELSE 'Do Not Show'
ENDDavid Cunningham
** Was this post helpful? Click Agree 😀, Like 👍️, or Awesome ❤️ below **
** Did this solve your problem? Accept it as a solution! ✔️**0 -
@david_cunningham This is exactly what I need. Thank you so much, appreciate your help.
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 292 Workbench
- 4 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 95 SQL DataFlows
- 603 Datasets
- 2.1K Magic ETL
- 3.7K Visualize
- 2.4K Charting
- 697 Beast Mode
- 43 App Studio
- 39 Variables
- 658 Automate
- 170 Apps
- 441 APIs & Domo Developer
- 42 Workflows
- 5 DomoAI
- 32 Predict
- 12 Jupyter Workspaces
- 20 R & Python Tiles
- 388 Distribute
- 111 Domo Everywhere
- 271 Scheduled Reports
- 6 Software Integrations
- 113 Manage
- 110 Governance & Security
- 9 Domo University
- 30 Product Releases
- Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 98 Community Announcements
- Domo Community Gallery
- 4.8K Archive