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 select "yes" above
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 select "yes" above
0
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 295 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 608 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 710 Beast Mode
- 50 App Studio
- 39 Variables
- 668 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 45 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 116 Manage
- 113 Governance & Security
- Domo Community Gallery
- 31 Product Releases
- 9 Domo University
- 5.3K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 103 Community Announcements
- 4.8K Archive