Is there a Beastmode I can configure for Rolling 30 period?
The caveat is the 30 day period I want to configure is Previous Month Second Tuesday to Current Month Second Tuesday.
Any assistance is appreciated in advance.
Thanks
Michael
Best Answer
-
To determine the 2nd Tuesday of the month, you could use the DAYNAME function and the DAY function. The 2nd Tuesday of the month can only occur between the 8th and the 4th of the month, so you could write a beast mode like this:
CASE WHEN DAY('date') >= 8 AND DAY('date') <=14 AND DAYNAME('date') = 'Tuesday' THEN '2nd Tuesday' ELSE 'Some other day' END
You could also use DATE_SUB with the current date to go back one month
**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
Answers
-
I would look at this post by @GrantSmith who lays out this functionality nicely.
**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 -
This is great information in regards to calculating rolling average however, what I am attempting to is create a time period/date function for Microsoft Patch Tuesday's that looks at "last_sync" date field with "Review Period is between Previous Month Second Tuesday to Current Month Second Tuesday = True".
One idea I had was to create a Beast Mode with CASE statement to set the current year (and subsequent 4-5 years) month's second Tuesday's something like this:
CASE when 'last_sync' = '05-11-2021' then 'May 2021 Patch Tuesday' else
when 'last_sync' = '06-08-2021' then 'June 2021 Patch Tuesday' else
and continuing through the year(s).
The difficulty is the review period is not Last 30 days, which would be easy enough, but second Tuesday to second Tuesday.
Thanks!
Michael
0 -
To determine the 2nd Tuesday of the month, you could use the DAYNAME function and the DAY function. The 2nd Tuesday of the month can only occur between the 8th and the 4th of the month, so you could write a beast mode like this:
CASE WHEN DAY('date') >= 8 AND DAY('date') <=14 AND DAYNAME('date') = 'Tuesday' THEN '2nd Tuesday' ELSE 'Some other day' END
You could also use DATE_SUB with the current date to go back one month
**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
- All Categories
- 1.9K Product Ideas
- 1.9K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 305 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3K Transform
- 106 SQL DataFlows
- 646 Datasets
- 2.2K Magic ETL
- 4K Visualize
- 2.5K Charting
- 774 Beast Mode
- 75 App Studio
- 43 Variables
- 728 Automate
- 186 Apps
- 467 APIs & Domo Developer
- 61 Workflows
- 14 DomoAI
- 40 Predict
- 17 Jupyter Workspaces
- 23 R & Python Tiles
- 403 Distribute
- 117 Domo Everywhere
- 277 Scheduled Reports
- 9 Software Integrations
- 136 Manage
- 133 Governance & Security
- 8 Domo Community Gallery
- 44 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 112 Community Announcements
- 4.8K Archive