Love the AlaSQL "Query JSON with SQL" function - this solves a lot of problems and makes Retool way more dynamic. However, the pivot operation performed here only works properly 1 time out of 5. If there were a way to toggle a pivot (as opposed to making a transformer), Retool would be a shoo-in for those migrating away from Google sheets, Chartio - going out of service in march, PowerBi, Tableau, and other charting tools
Related topics
| Topic | Replies | Views | Activity | |
|---|---|---|---|---|
| Retool database dynamic pivot operation | 4 | 1408 | April 20, 2024 | |
| Dynamic Pivot Table Creation | 2 | 117 | January 23, 2026 | |
| Pivot Table for data exploration | 20 | 6756 | January 24, 2025 | |
| Pivot Table functionality | 21 | 1953 | April 15, 2025 | |
| Control table column order with dynamic query | 22 | 5053 | June 7, 2023 |