Best Mode Formula for 2 Month Period
Options

Tsharma8724
Member
in Magic ETL
Hi Everyone,
I require help to create beast mode for 2 month period which would be like a Filter on the Dashboard. For example: Jan-Feb, Mar -Apr, May-Jun, Jul-Aug, Sep-Oct, Nov-Dec
0
Comments
-
You could create a beast mode based on your date field by doing something like this:
CASE WHEN MOD(MONTH(`date`),2) = 0 THEN CONCAT( DATE_FORMAT(DATE_SUB(`date`, interval 1 month),'%b'),'-',DATE_FORMAT(`date`,'%b')) ELSE CONCAT( DATE_FORMAT(`date`,'%b'),'-',DATE_FORMAT(DATE_ADD(`date`, interval 1 month),'%b')) END
You would want to make sure your date field has dates for all months and then you want to make sure you click the checkbox "share calculation on dataset" when creating the beast mode and your other cards on the dashboard use that same dataset. This will ensure all the cards filter properly when selecting any of these month groups.
**Check out my Domo Tips & Tricks Videos
**Make sure toany users posts that helped you.
**Please mark as accepted the ones who solved your issue.1
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Data Connections
- 1.3K Connectors
- 309 Workbench
- 17 Cloud Integrations
- Data & ETL
- 2.3K Magic ETL
- 120 SQL DataFlows
- 666 Datasets
- Visualize & Apps
- 90 App Studio
- 198 Pro-code Components
- 2.6K Charting & Analyzer
- 873 Calculations & Variables (Beast Mode)
- AI & Data science
- 23 Domo AI & AI Chat
- 4 Managing AI
- 18 Jupyter Workspaces
- Automate
- 122 Workflows
- Alerts
- Distribute
- 118 Domo Everywhere
- 284 Reporting
- Manage
- 145 Governance & Security
- 489 APIs
- 11 Add-ins & Plugins
- 13 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 118 Community Announcements
- 5K Archive