How to filter dates for last activity for the last 2 weeks?
Comments
-
Unless there is a specific date field that identifies "Most Recent Activity Date" or something like that, you would need to have something like that created via Data Transform.
It would need to do a periodic compare of "new" data against a non-updated source, identify records where there is a mismatch, and update an Activity Date column with the current date as the "last time active" before then resaving as your new non-live version of data.
I know that probably wasn't the answer you were looking for, but hopefully it can help spark the right conversations at your organization to get something like that in place for you.
-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
Categories
- All Categories
- Product Ideas
- 2.1K Ideas Exchange
- Connect
- 1.3K Connectors
- 309 Workbench
- 7 Cloud Amplifier
- 10 Federated
- Transform
- 666 Datasets
- 120 SQL DataFlows
- 2.3K Magic ETL
- 827 Beast Mode
- Visualize
- 2.6K Charting
- 90 App Studio
- 46 Variables
- Automate
- 198 Apps
- 489 APIs & Domo Developer
- 98 Workflows
- 24 Code Engine
- AI and Machine Learning
- 23 AI Chat
- 4 AI Projects and Models
- 18 Jupyter Workspaces
- Distribute
- 118 Domo Everywhere
- 284 Scheduled Reports
- 11 Software Integrations
- Manage
- 145 Governance & Security
- 13 Domo Community Gallery
- 49 Product Releases
- 13 Domo University
- Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 117 Community Announcements
- 5K Archive