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 to any 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?
“There is a superhero in all of us, we just need the courage to put on the cape.” -Superman1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 297 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 54 App Studio
- 40 Variables
- 678 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 46 Workflows
- 8 DomoAI
- 34 Predict
- 14 Jupyter Workspaces
- 20 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 121 Manage
- 118 Governance & Security
- Domo Community Gallery
- 32 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive