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.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.2K Connectors
- 284 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.9K Transform
- 89 SQL DataFlows
- 556 Datasets
- 2.2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 569 Beast Mode
- 10 App Studio
- 27 Variables
- 578 Automate
- 140 Apps
- 414 APIs & Domo Developer
- 23 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 350 Distribute
- 90 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 92 Manage
- 89 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 85 Community Announcements
- 4.8K Archive