How to create a filter to capture the end of month
Hello Domo community -
Good Day!
Basically, we want to capture the data from the previous month on the current week.
for example, the start of the week is 8/28 and the end of the week is 9/3.
we want to capture all data up to 8/31 only. and then data for 9/1 to 9/3
using the start date 8/28 or end date 9/3.
Thanks
Comments
-
build a date dimension where you have one row for each day of the year. then assign the week_of_year to each date. then it'll be easier to make these comparisons.
"build a date dimension" in SQL is a google-able term, so you should be able to implement that using MySQL dataflows.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1 -
Hi @jaeW_at_Onyx
I am not sure how to assign the date to my dataset
here's what my data looks like>>>
I created a date dimension(date) and joined it to my end date column
not sure how to show that Friday is for this date and Thursday is for this date based of the Start and End date ranges.
for example, in the first row, I want to say that Wednesday is 3/28/2018 and Friday is 3/30/2018.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 296 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 614 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 729 Beast Mode
- 53 App Studio
- 40 Variables
- 677 Automate
- 173 Apps
- 451 APIs & Domo Developer
- 45 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