Homepage
Recent Changes
Search:
History of 2025-10-13 Grouping rows by values in a column
2025-10-13
05:43 UTC
Revision 1
. . . .
mbork
–
A few days ago I needed to analyze some tabular data where some rows where grouped in a natural way. Imagine for example a database table which stores events, and every event is related to a user. For example, it could have a user_id column, a timestamp column and an event_type column. I want to see all the events, but events related to different users should be visually spearated (as they are completely unrelated). A natural way would be to sort the data by user_id first and by timestamp next. Ideally, groups of events related to different users would be separated by e.g. an empty row.