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
- 10.5K All Categories
- 6 Connect
- 916 Connectors
- 250 Workbench
- 462 Transform
- 1.7K Magic ETL
- 69 SQL DataFlows
- 476 Datasets
- 189 Visualize
- 252 Beast Mode
- 2.1K Charting
- 11 Variables
- 16 Automate
- 354 APIs & Domo Developer
- 88 Apps
- 3 Workflows
- 20 Predict
- 5 Jupyter Workspaces
- 15 R & Python Tiles
- 246 Distribute
- 62 Domo Everywhere
- 243 Scheduled Reports
- 21 Manage
- 42 Governance & Security
- 172 Product Ideas
- 1.2K Ideas Exchange
- 11 Community Forums
- 27 Getting Started
- 14 Community Member Introductions
- 55 Community News
- 4.5K Archive