How to Build Tableau Viewership Analytics Using PostgreSQL Repository Data

·2 views

A developer has shared a PostgreSQL query that taps into Tableau's internal repository to generate detailed viewership analytics beyond the platform's basic 'Who has seen this view?' panel. The query pulls 'Access View' events from the past 90 days and joins them with workbook and user history tables to produce per-viewer view counts and last-seen timestamps. It is designed to surface unviewed workbooks alongside active ones, giving dashboard creators a complete picture of content engagement. The author notes key caveats, including using workbook_id rather than snapshot IDs for stable long-term tracking, verifying where friendly_name is populated in a given Tableau version, and optionally filtering out self-views by publishers. The query serves as the backbone of a self-service analytics dashboard featuring KPI tiles, time-series trends, and a color-coded recency table.

Read the full story at DEV Community

This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)

Textparser offers high-performance C parsing engine with Python-compiled grammars

A developer has introduced Textparser, a hybrid parsing engine that combines JSON, Python, and C to simplify language parsing workflows. The tool aims to bridge the gap between complex traditional parser generators like Flex/Bison and difficult-to-maintain hand-written parsers. Textparser ships with ready-to-use grammar files for over 30 languages, including C, C++, Rust, Python, JavaScript, HTML, and SQL. Each parsed token carries metadata such as code coordinates, structural flags, and syntax styling options. The project is designed for lightweight use cases like terminal text editors, syntax highlighters, and custom linters where full compiler front-ends would be excessive.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

University of Minnesota Scientists Build World's First Fully Synthetic Cell from Scratch

Researchers at the University of Minnesota, led by Associate Professors Kate Adamala and Aaron Engelhart, have created SpudCell, the world's first synthetic cell built entirely from non-living chemical components rather than derived from any existing organism. The cell can grow, feed, replicate its genetic material, and divide — completing a full life cycle driven purely by chemistry. SpudCell's genome is just 90 kilobase pairs, a fraction of the human genome's 3 billion base pairs, and is precisely minimal by design, with every molecular component intentional and fully documented. Because researchers have a complete blueprint and ingredient list, individual components can be swapped out, making the system highly programmable and experimentally flexible. Experts say the breakthrough frees synthetic biology from the evolutionary constraints of natural cells, potentially enabling biological systems to perform functions that living cells cannot easily achieve.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

How Developers Can Break Free From Passive Learning and Start Creating

Many developers fall into a 'learning vacuum' where they endlessly consume tutorials, courses, and articles without producing anything tangible. A DEV Community writer outlines practical steps to shift from passive absorption to active output, starting with simply documenting what you build each day. Taking on small personal projects, even ones with no real-world utility, can reignite motivation and provide hands-on experience that tutorials cannot replicate. Engaging with developer communities — whether online forums, Discord servers, or local meetups — helps transform isolated learning into shared, applied knowledge. Writing about concepts you have recently mastered, no matter how basic they seem, reinforces understanding and builds confidence in your own abilities.

0 comments Read more at DEV Community

ProgrammingHacker News ·

Infracost Seeks Marketing Lead to Drive FinOps Awareness

Infracost, a Y Combinator Winter 2021 alumni company, is currently hiring for a Marketing Lead position. The company focuses on FinOps, a practice that aims to bring cloud cost management earlier into the software development lifecycle. The job listing was posted on Y Combinator's company job board. No further details about the role's requirements or compensation were publicly available in the listing.

0 comments Read more at Hacker News