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.2K Connectors
- 284 Workbench
- 4 Cloud Amplifier
- 4 Federated
- 2.9K Transform
- 88 SQL DataFlows
- 554 Datasets
- 2.2K Magic ETL
- 3.3K Visualize
- 2.3K Charting
- 562 Beast Mode
- 9 App Studio
- 27 Variables
- 577 Automate
- 140 Apps
- 414 APIs & Domo Developer
- 22 Workflows
- 1 DomoAI
- 28 Predict
- 12 Jupyter Workspaces
- 16 R & Python Tiles
- 350 Distribute
- 90 Domo Everywhere
- 258 Scheduled Reports
- 2 Software Integrations
- 91 Manage
- 88 Governance & Security
- 9 Product Release Questions
- Community Forums
- 42 Getting Started
- 28 Community Member Introductions
- 85 Community Announcements
- 4.8K Archive