How should filter the last month data using Magic ETL?
I need to do some calculations using the last month data with Magic ETL but I not able to filter.
For example the data between 01/01/2018 and 31/01/2018 inclusive.
I was thinking to calculate the first day of the last month and the last day of the month but it is getting complicated.
Is this possible using Magic ETL?
Thanks
Comments
-
I'm it's probably possible with the Magic ETL, however I'm more accustomed to the SQL transform.
If you did this SQL transform, you could limit your data to only last month.
SELECT *
FROM table
WHERE `datefield` >= DATE_SUB(DATE_FORMAT(`datefield`, '%Y-%m-01'), INTERVAL 1 MONTH)
AND `datefield` <= LAST_DAY(DATE_SUB(CURRENT_DATE, INTERVAL 1 MONTH))Hopefully this might help. Or if not, maybe someone else can chime in regarding the Magic ETL.
Sincerely,
ValiantSpur
**Please mark "Accept as Solution" if this post solves your problem
**Say "Thanks" by clicking the "heart" in the post that helped you.0 -
Thanks Also, I thought it was the best way to go.
I solved with this sql. It needs to be filtered with the right year as well .
SELECT * from all_members_data_raw
WHERE (EXTRACT(MONTH from `Member Start Date`) = EXTRACT(MONTH FROM DATE_SUB(now(),INTERVAL 1 MONTH))
AND EXTRACT(YEAR from `Member Start Date`) = EXTRACT(YEAR FROM DATE_SUB(now(),INTERVAL 1 MONTH)))0
Categories
- All Categories
- 2K Product Ideas
- 2K Ideas Exchange
- 1.6K Connect
- 1.3K Connectors
- 311 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 3.8K Transform
- 656 Datasets
- 115 SQL DataFlows
- 2.2K Magic ETL
- 813 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 81 App Studio
- 45 Variables
- 771 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 77 Workflows
- 23 Code Engine
- 36 AI and Machine Learning
- 19 AI Chat
- AI Playground
- AI Projects and Models
- 17 Jupyter Workspaces
- 410 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 10 Software Integrations
- 142 Manage
- 138 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 114 Community Announcements
- 4.8K Archive