Greg Rossi

Turns out you can filter aggregations in PostgreSQL outside of the WHERE clause.

How to create a Hierarchy for This Quarter to date over Prior Quarter to date Analysis that allows the user to drill from month in quarter to week to day in both quarters on a dual axis, maintaining comparative analysis.

See a special technique for hiding Tableau dashboard filters until an action is initiated. View this article for full instructions!

In this post, I will show you a calculation to display the aggregation of up to date data (by month) that will automatically update over time and is safe to use with actions and filters.