Beast mode for dates

I have a dataset that looks like this:
Date. Customers
Jan 01. 20
Jan 02 22
Jan 03 26
Jan 04. 29
What I would like to do as a beast mode filter is to only include the first day of each month. So I want a filter that just filers Jan01, Feb01, March01, etc. Is this possible? I would assume it would be some data beast mode function. Any help would be appreciated!
Answers
-
If you only wanted to show dates that are the first of the month you could create a beast mode like this:
CASE WHEN DAYOFMONTH(datefield) = 1 THEN datefield END
You could also create an include/exclude filter logic and then drag this beast mode into your filters and filter to include:
CASE WHEN DAYOFMONTH(datefield) = 1 THEN 'Include' ELSE 'Exclude' END
**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.0 -
@mroker - in this case, because you have 4 dates in January…
Would you only want to see the customers associated with Jan 01, which would be 20? If so, then @MarkSnodgrass has a great solution for you.
Or do you want to see the sum of all the days (20, 22, 26, 29) or 97? or the average 24.25?
1
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Connect
- 1.3K Connectors
- 309 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 664 Datasets
- 120 SQL DataFlows
- 2.3K Magic ETL
- 824 Beast Mode
- Visualize
- 2.6K Charting
- 86 App Studio
- 46 Variables
- Automate
- 194 Apps
- 486 APIs & Domo Developer
- 90 Workflows
- 24 Code Engine
- AI and Machine Learning
- 23 AI Chat
- 4 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 119 Domo Everywhere
- 283 Scheduled Reports
- 11 Software Integrations
- Manage
- 143 Governance & Security
- 11 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 116 Community Announcements
- 5K Archive