Freezing card at end of Fiscal Year
Hello everyone,
I was curious to know if there is any mechanism in Domo where I could freeze the content of 50 cards that are part of the same dashboard so that on the last day of the Fiscal Year we "freeze" the cards and the dashboard and then the data would become static but obviously with drill down capabilities.
It is OK if we make a copy of the dashboard and cards (so we create new objects if needed) but want to minimize work so that we we do not have to recreate Beast Modes to reflect the previous fiscal year.
Any suggestions on where to start looking or how could this be done would be really appreciated.
Thank you
F
Best Answer
-
consider adding a "is_closed_period" column. that way you can filter on transactions that are part of the closed period and functionally "freeze" the data.
alternatively, if you label transactions as belonging to the nth period (1,2,3,4th etc.) you could filter on "all activity from the 3 closed period or earlier"
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1
Answers
-
0
-
consider adding a "is_closed_period" column. that way you can filter on transactions that are part of the closed period and functionally "freeze" the data.
alternatively, if you label transactions as belonging to the nth period (1,2,3,4th etc.) you could filter on "all activity from the 3 closed period or earlier"
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1 -
Hi Jae,
Thank you for taking the time to answer my question.
You solution involves making changes to both the dataset(s) and the cards - and it might be the way to go.
I was looking to see if there is some Domo functionality where you could make a copy of the datasets and cards and have these work together so that would give the appearance of a freezing mechanism. This would have minimized the amount of work on our side.
Thanks again.
F
0 -
@FXM32 Domo does retain dataset history in Vault, but that's supposed to be a recovery tool not dataset snapshots that end users can flip between.
Given that your "freezing mechanism" should tightly align with business logic, it makes sense that you should apply that business logic as an artificat in your dataset that you can control via ETL and filtering.
Jae Wilson
Check out my 🎥 Domo Training YouTube Channel 👨💻
**Say "Thanks" by clicking the ❤️ in the post that helped you.
**Please mark the post that solves your problem by clicking on "Accept as Solution"1
Categories
- All Categories
- 1.7K Product Ideas
- 1.7K Ideas Exchange
- 1.5K Connect
- 1.2K Connectors
- 294 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.8K Transform
- 97 SQL DataFlows
- 607 Datasets
- 2.1K Magic ETL
- 3.8K Visualize
- 2.4K Charting
- 707 Beast Mode
- 49 App Studio
- 39 Variables
- 667 Automate
- 170 Apps
- 446 APIs & Domo Developer
- 44 Workflows
- 7 DomoAI
- 33 Predict
- 13 Jupyter Workspaces
- 20 R & Python Tiles
- 391 Distribute
- 111 Domo Everywhere
- 274 Scheduled Reports
- 6 Software Integrations
- 115 Manage
- 112 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