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 | 1366 | April 20, 2024 | |
| Pivot Table for data exploration | 20 | 6570 | January 24, 2025 | |
| Pivot Table functionality | 21 | 1677 | April 15, 2025 | |
| Control table column order with dynamic query | 22 | 4913 | June 7, 2023 | |
| Building a Plotly stacked bar chart in Retool | 6 | 2247 | May 27, 2024 |