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
- 1.4K Product Ideas
- 1.4K Ideas Exchange
- 1.4K Connect
- 1.1K Connectors
- 282 Workbench
- 3 Cloud Amplifier
- 4 Federated
- 2.8K Transform
- 86 SQL DataFlows
- 548 Datasets
- 2.2K Magic ETL
- 3.2K Visualize
- 2.3K Charting
- 544 Beast Mode
- App Studio
- 26 Variables
- 566 Automate
- 134 Apps
- 411 APIs & Domo Developer
- 21 Workflows
- DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 345 Distribute
- 87 Domo Everywhere
- 257 Scheduled Reports
- 1 Software Integrations
- 85 Manage
- 84 Governance & Security
- 8 Product Release Questions
- Community Forums
- 41 Getting Started
- 27 Community Member Introductions
- 81 Community Announcements
- 4.8K Archive