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.2K Product Ideas
- 1.2K Ideas Exchange
- 1.3K Connect
- 1.1K Connectors
- 273 Workbench
- 2 Cloud Amplifier
- 3 Federated
- 2.7K Transform
- 78 SQL DataFlows
- 525 Datasets
- 2.1K Magic ETL
- 2.9K Visualize
- 2.2K Charting
- 435 Beast Mode
- 22 Variables
- 513 Automate
- 115 Apps
- 390 APIs & Domo Developer
- 8 Workflows
- 26 Predict
- 10 Jupyter Workspaces
- 16 R & Python Tiles
- 332 Distribute
- 77 Domo Everywhere
- 255 Scheduled Reports
- 66 Manage
- 66 Governance & Security
- 1 Product Release Questions
- Community Forums
- 40 Getting Started
- 26 Community Member Introductions
- 68 Community Announcements
- 4.8K Archive