Hacker News Reader

Very nice. I've been building on something similar myself, but this looks like you came quite far.

Further to this - Does it have the ability to render pivot tables from two-dimensional results? Or cohort charts? These are visualisations that I find very useful.

View on HN

Thanks troels! It doesn't but it's something we could keep in mind. Feel free to open an issue on GitHub to make the request. Do you have any examples of what you have in mind?

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.

Reply on news.ycombinator.com