How can you use a relative date filter in the DOMO Campaigns distribution list filter?
For example, in my DOMO campaign distribution list data source I can have a filter for sale_date is greater than or equal to 6/1/2022. However, what language do I use in the distribution list if I want this date filter to be prior month? Or Last 5 days? Or Prior Year, etc...
The following link references that the filter in the distribution list should include the dataset column name (sale_date), the operands and the value of the filter - but does not explain how to make the value relative to the current date.
Any help would be appreciated. Thanks.
Answers
-
Hi @Julie_H ,
So I think you should use a formula trick called "Interval". I answered a previous question around previous dates here: https://www.youtube.com/watch?v=LQZS8NKX-Gg&list=PLLbgJInsMl7o3pPpLmyVe1AsxwX2OEJGO&index=2
So you can saw date - interval 5 day or date- interval 1 year etc
Let me know if this makes sense,
John Le
More video solutions at https://www.dashboarddudes.com/pantry
John Le
Are you on my newsletter? If not, signup here so you don't miss out on my Domo tricks, alerts about my webinars, cooking tips and more
Signup here:
1 -
Thanks @DashboardDude, I appreciate your suggestion. That would work if I was using a card, however I am attaching an excel file to the campaign directly from the data source so can't create beast mode calculations. I had thought about creating different fields in the data source that would subtract the current date from the transaction date, and then using that in my filter, or a month column, and year column in the data source, but that is a lot of extra fields. Was hoping there was syntax I could use in the distribution list filters to do the same thing. If you have any other thoughts or suggestions, please let me know.
0 -
Hi @Julie_H ,
Got it. Feel free to book 30 min with me and maybe I can take a look. I think I need to see what you're doing to help. Again, only if you want to. https://www.dashboarddudes.com/book-a-dude
Happy to help,
John Le
More video solutions at https://www.dashboarddudes.com/pantry
John Le
Are you on my newsletter? If not, signup here so you don't miss out on my Domo tricks, alerts about my webinars, cooking tips and more
Signup here:
1
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
- 659 Datasets
- 116 SQL DataFlows
- 2.2K Magic ETL
- 816 Beast Mode
- 3.3K Visualize
- 2.5K Charting
- 82 App Studio
- 46 Variables
- 776 Automate
- 190 Apps
- 481 APIs & Domo Developer
- 82 Workflows
- 23 Code Engine
- 41 AI and Machine Learning
- 20 AI Chat
- 1 AI Playground
- 2 AI Projects and Models
- 18 Jupyter Workspaces
- 411 Distribute
- 120 Domo Everywhere
- 280 Scheduled Reports
- 11 Software Integrations
- 145 Manage
- 141 Governance & Security
- 8 Domo Community Gallery
- 48 Product Releases
- 12 Domo University
- 5.4K Community Forums
- 41 Getting Started
- 31 Community Member Introductions
- 115 Community Announcements
- 4.8K Archive