Ai Chat

Advanced Dynamic Reporting Dashboard with Nested Pivot Aggregations

dashboard pivot tables aggregation data visualization google apps script
Prompt
Design a comprehensive Google Sheets dashboard that dynamically pulls complex aggregation data from a PostgreSQL database using Google Apps Script. The dashboard should support multi-level pivot analysis with nested hierarchical calculations, including rolling 12-month averages, quarter-over-quarter comparisons, and adaptive filtering. Include error handling for null values and implement a modular architecture that allows seamless data refresh without manual intervention.
Sign in to see the full prompt and use it directly
Sign In to Unlock
Use This Prompt
0 uses
1 views
Pro
SQL
General
Feb 28, 2026

How to Use This Prompt

1
Copy the prompt Click "Copy" or "Use This Prompt" above
2
Customize it Replace any placeholders with your own details
3
Generate Paste into Ai Chat and hit generate
Link copied!