Using a Dashboard Filter to generate Purchases From 12 Months Prior to start date

I have a dataset that shows details from received Purchase Orders (inventory) that our company buys.
If for instance a user sets up a date filter on this data, we also want to show the received purchase orders for the same vendor for the receipts starting 365 days prior to the Start date of the Date filter on the dashboard.
Example: User selects all receipts > 1/1/2023, and would then view this data, but would also see (on a separate card on same page) a Summary of the purchases from that Vendor for 1/1/2022 thru 12/31/2022. It must be dynamic so that if the user chose a different date range on the Dashboard, the 2nd card would adjust accordingly.
I have successfully setup YOY sales dashboards, but they are based on Current YTD vs Prior YTD and so are not dynamically adjusting dates. This one is throwing me for a loop.
Best Answers
-
I'd recommend utilizing a custom date dimension which would allow you to have a singularly selected date but then allow you to show last year's data. I've done a write up on this in the past you can find here:
Essentially your second graph would have there the period type = last year.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
You could use a beastmode that is something like this:
CASE WHEN `Date field` >= `date` - INTERVAL 365 DAY THEN 'In' ELSE 'Out' END
When users adjust the date filter then this beastmode will dynamically show data that is within the last 365 days.
If I solved your problem, please "accept" my answer as the solution
0
Answers
-
I'd recommend utilizing a custom date dimension which would allow you to have a singularly selected date but then allow you to show last year's data. I've done a write up on this in the past you can find here:
Essentially your second graph would have there the period type = last year.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**0 -
You could use a beastmode that is something like this:
CASE WHEN `Date field` >= `date` - INTERVAL 365 DAY THEN 'In' ELSE 'Out' END
When users adjust the date filter then this beastmode will dynamically show data that is within the last 365 days.
If I solved your problem, please "accept" my answer as the solution
0
Categories
- All Categories
- 1.1K Product Ideas
- 1.1K Ideas Exchange
- 1.2K Connect
- 970 Connectors
- 259 Workbench
- Cloud Amplifier
- 1 Federated
- 2.4K Transform
- 76 SQL DataFlows
- 502 Datasets
- 1.8K Magic ETL
- 2.7K Visualize
- 2.2K Charting
- 379 Beast Mode
- 21 Variables
- 487 Automate
- 104 Apps
- 379 APIs & Domo Developer
- 6 Workflows
- 22 Predict
- 6 Jupyter Workspaces
- 16 R & Python Tiles
- 319 Distribute
- 67 Domo Everywhere
- 252 Scheduled Reports
- 59 Manage
- 59 Governance & Security
- 1 Product Release Questions
- 5K Community Forums
- 37 Getting Started
- 23 Community Member Introductions
- 64 Community Announcements
- 4.8K Archive