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.5K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 8 Federated
- 2.9K Transform
- 100 SQL DataFlows
- 616 Datasets
- 2.2K Magic ETL
- 3.8K Visualize
- 2.5K Charting
- 738 Beast Mode
- 56 App Studio
- 40 Variables
- 684 Automate
- 176 Apps
- 452 APIs & Domo Developer
- 46 Workflows
- 10 DomoAI
- 35 Predict
- 14 Jupyter Workspaces
- 21 R & Python Tiles
- 394 Distribute
- 113 Domo Everywhere
- 275 Scheduled Reports
- 6 Software Integrations
- 123 Manage
- 120 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 108 Community Announcements
- 4.8K Archive