Instance Hygiene
Trying to clean up an instance and find where data can be a visualization vs. ETL. Wish to remove cards that not have been used in the last 6 months. When looking at "last view" timestamp, which is accurate when it comes to page vs. card?
For example, cards exists that have not been looked at, but these have appeared on pages that have been viewed recently. I want to avoid removing cards that may still be viewed but perhaps not clicked on and only from the page.
Best Answers
-
@soozalooz You can use the Domo Governance Cards and Pages dataset to join page views to the cards within a dataflow. Then group by Card ID to to find the maximum of Last View directly on the card or on an associated page.
2 -
Cards aren't considered "viewed" by the DomoStats unless the detail view is looked at. When looking at a card on a page it doesn't count that as a card view. As @MichelleH mentioned you can utilize the Domo Governance or Domo Stats connectors for pull the last viewed information for pages and join each card on that page together to get the page last viewed and the card last viewed. Selecting the greatest of these will get you when the card was last viewed.
One caveat is that you may want to ignore page or card views done by Major Domos. You could utilize the Activity Log to see when cards or pages are actually being viewed and can filter out specific users.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1
Answers
-
@soozalooz You can use the Domo Governance Cards and Pages dataset to join page views to the cards within a dataflow. Then group by Card ID to to find the maximum of Last View directly on the card or on an associated page.
2 -
Cards aren't considered "viewed" by the DomoStats unless the detail view is looked at. When looking at a card on a page it doesn't count that as a card view. As @MichelleH mentioned you can utilize the Domo Governance or Domo Stats connectors for pull the last viewed information for pages and join each card on that page together to get the page last viewed and the card last viewed. Selecting the greatest of these will get you when the card was last viewed.
One caveat is that you may want to ignore page or card views done by Major Domos. You could utilize the Activity Log to see when cards or pages are actually being viewed and can filter out specific users.
**Was this post helpful? Click Agree or Like below**
**Did this solve your problem? Accept it as a solution!**1 -
If I remember correctly you'll need to link pages to cards to datasets, which can cause some cardinality issues, but then you can also credit a card/dataset when a page gets viewed vs. just when a card gets viewed.
0 -
thank you, all! @GrantSmith, how do we filter out specific users? I can see how we can filter in users but not exclude ones.
0
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 753 Beast Mode
- 61 App Studio
- 41 Variables
- 692 Automate
- 177 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive