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
You're only one dashboard away.
Click here for more video solutions:
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
You're only one dashboard away.
Click here for more video solutions:
1
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
- 6 Product Release Questions
- Community Forums
- 41 Getting Started
- 27 Community Member Introductions
- 81 Community Announcements
- 4.8K Archive