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