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.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 738 Beast Mode
- 57 App Studio
- 40 Variables
- 685 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 124 Manage
- 121 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive