Best Mode Formula for 2 Month Period

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
- 10.5K All Categories
- 8 Connect
- 918 Connectors
- 250 Workbench
- 472 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 477 Datasets
- 203 Visualize
- 255 Beast Mode
- 2.1K Charting
- 12 Variables
- 17 Automate
- 354 APIs & Domo Developer
- 89 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 247 Distribute
- 63 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 181 Product Ideas
- 1.2K Ideas Exchange
- 12 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive