Hacker News new | ask | show | jobs
by troels 3845 days ago
For a pivot, simply take a resultset that gives three columns and map the first to the X axis, the second to the Y and the third as values. It's very often that I find myself pulling that kind of data out in reports.

Making a general purpose cohort chart (https://blog.modeanalytics.com/cohort-analysis-helps-look-ah...) is probably a bit harder, since it requires a relatively complex query to generate the data. Would probably work best with a sort of macro or template system in place.