Instance Hygiene

soozalooz · 2023-08-28T18:29:00+00:00

There was an error rendering this rich post.

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.

Find more posts tagged with

Cards

Pages

Accepted answers

MichelleH

@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.

GrantSmith

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.

All comments

MichelleH

GrantSmith

trafalger

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.

soozalooz

thank you, all! @GrantSmith, how do we filter out specific users? I can see how we can filter in users but not exclude ones.