Pivot, Grouping, Crosstab

[mshiner]

Hi

Hopefully this is the right place to put this.

I've just revisited TAD and can see that after a hiatus there's some new and really exciting stuff going on.... particularly the ability of TAD to be run as a web app and the DuckDB integration.

Originally I got confused by TAD because I was looking for a way to do Pivot Tables as understood by Excel and LibreOffice - i.e. a Crosstab type visualization. The way Tad 'pivots' seems more like grouping than actual 'pivoting'.

My 'idea', such as it is, would be to rename the pivot functionality to 'group' and work towards some form of crosstab along the lines of this react library - only better, obviously. Not being familiar with React or the TAD code I don't know how feasible this is at all. It would be REALLY cool if it could be implemented, though, and would solve this issue for DuckDB.

Inspiration from the R world can be found here

Thoughts?

Martyn Shiner