Forum Discussion
date filtering
Hello, I have a report with several campaigns sort by weeks by budget. Some campaigns are paused or spend little and those I would like to filter. But I can't use a specific budget which is more than x because the campaign may start a few days ago.
I would like to filter something like, when the budget is more than x in the last 7 days, show it.
actual week 41
Something like this should be a result:
Thanks
| campaign | week 38 | week 39 | week 40 | week 41 |
| campaign 1 | 300 (USD) | 0 | 50 | 30 |
| campaign 2 | 0 | 0 | 0 | 150 |
1 Reply
Anonymous
Can you share some sample data and the expected result to have a clear understanding of your question?
You can save your files in OneDrive, Google Drive, or any other cloud sharing platforms and share the link here.
____________________________________
How to paste sample data with your question?
How to get your questions answered quickly?
_____________________________________
Did I answer your question? Mark this post as a solution, this will help others!.Click on the Thumbs-Up icon if you like this reply 🙂
