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
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 7 Cloud Amplifier
- 9 Federated
- 3K Transform
- 114 SQL DataFlows
- 654 Datasets
- 2.2K Magic ETL
- 4.1K Visualize
- 2.5K Charting
- 806 Beast Mode
- 79 App Studio
- 44 Variables
- 761 Automate
- 189 Apps
- 480 APIs & Domo Developer
- 75 Workflows
- 17 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 408 Distribute
- 119 Domo Everywhere
- 279 Scheduled Reports
- 10 Software Integrations
- 141 Manage
- 137 Governance & Security
- 8 Domo Community Gallery
- 47 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive