4 ms·
Okay... so what is a pivot table? I've never used one or seen one used, and my browser didn't load the embedded video. What I learned about pivot tables from t
by digging 3y ago
Okay... so what is a pivot table? I've never used one or seen one used, and my browser didn't load the embedded video.
What I learned about pivot tables from this article:
- they are an easy way to show data that's in a spreadsheet
- they were invented at Lotus (maybe)
I don't even begin to know what they actually do or how someone would use one.
- airstrike 3y agoIt's a drag-and-drop UI for grouping items in a table by category. Plenty of quick videos on YT since business users generally struggle to grasp it. Here's one example: https://www.youtube.com/watch?v=qu-AK0Hv0b4 https://www.youtube.com/watch?v=qu-AK0Hv0b4 It's paradoxically very useful and complete garbage at the same time, IMHO
- 121789 3y agoWhy garbage? It has limitations but is incredibly useful for what it is
- airstrike 3y agoIt's just that the limitations feel like whoever was implementing it walked away from it before they were finished to work on a different project. It could be much better than it is. It's way too brittle and the UX for more advanced aggregations is downright painful.
- cdaringe 3y agoYa… I fee that. The only high quality ones on the web too are proprietary. Im using the plotly react pivot that gets the job done, but doesnt even compete with excel… 2010 edition . Would love a killer end all pivot integration. I have no idea what the ideal UX is, i just know that whatever I got aint it