Government Datasets and Activity Log including Card ID and Page ID
Hi, all.
I tried to count the number of time of "VIEW" of specific cards existing on several pages by Activity Log.
For the reason Activity Log has no records of Card ID and Page ID both, Card ID and Page ID cannot be linked.
I would like to know who viewed the cards from which page.
Is there any way to get log data of VIEW linked Card ID and Page ID both?
Thank you,
eriena
Best Answer
-
@eriena I haven't looked at the Activity Log closely, but it sounds like you're saying, if a card is shared to multiple pages, it can be difficult to know which page a user was on when they access a given card.
If that's true, you could do some ETL magic, and basically implement a LAG() function which asks "for each card view what was the most recent page a viewer viewed." Hopefully, that will accurately inform, which page a user was on before they clicked into a card.... but you'd have to do some testing to verify.
I think you'll have to implement this one in Redshift / MySQL because I think you'll want to implement your LAG on a CASE statement or JOIN on some sort of a weird subQuery.
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
-
@eriena I haven't looked at the Activity Log closely, but it sounds like you're saying, if a card is shared to multiple pages, it can be difficult to know which page a user was on when they access a given card.
If that's true, you could do some ETL magic, and basically implement a LAG() function which asks "for each card view what was the most recent page a viewer viewed." Hopefully, that will accurately inform, which page a user was on before they clicked into a card.... but you'd have to do some testing to verify.
I think you'll have to implement this one in Redshift / MySQL because I think you'll want to implement your LAG on a CASE statement or JOIN on some sort of a weird subQuery.
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.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 101 SQL DataFlows
- 622 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 748 Beast Mode
- 59 App Studio
- 41 Variables
- 686 Automate
- 176 Apps
- 453 APIs & Domo Developer
- 47 Workflows
- 10 DomoAI
- 36 Predict
- 15 Jupyter Workspaces
- 21 R & Python Tiles
- 396 Distribute
- 113 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 125 Manage
- 122 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 10 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 109 Community Announcements
- 4.8K Archive