The Ultimate Pivot table
Over the last few months, I’ve discussed grid components, aggregating and pivoting with a lot of people. You would not believe how much users want to see a good grid component that allows drill down and how strongly they hold opinions on certain solutions. I have examined a lot of existing solutions, everything from excel, to powerBI, Oracle, DuckDB, hypertree, grafana, tableau……. I think I’m beginning to converge these ideas and requests into a pivot table that will be a good solution for our users:
- Like all of our work, it should be really really fast
- It must work with Big Data
- It should be Friendly
- It must allow changing aggregations – e.g. Group by exchange OR group by exchange and sym
- Allow pivoting some calculations – from one column to a breakdown in separate columns
- It must work for all databases.
Well now the proposed interface looks like this:
Pulse - Pivot
A lot of the functionality inspiration should be credited to Stevan Apter and HyperTree. Ryan had seen HyperTree and loved the functionality and beautiful kdb only implementation. The challenge was to allow similar functionality for all databases while making it more accessible. We now have a working demo version.
If you love pivot tables and have never got to see your dream grid component come to fruition, we want to build it, so get in touch.